Get startedGet started for free

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

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise