Matching text types
While there are a small number of text data types in PostgreSQL, each type is best utilized for representing character sequences with different characteristics. These differences are subtle in the case of using a VARCHAR(N) column versus a CHAR(N) column. However, there are benefits to be realized by making the correct choice. In this exercise, you will have an opportunity to reason about which text-based data type to use when representing different types of data values.
This exercise is part of the course
Creating PostgreSQL Databases
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
