EasyEnv
PostgreSQL
IntermediateLesson 4 of 1425 min · hands-on

Data Types

Part of the PostgreSQL course

Every column you have created so far has had a type attached to it, TEXT, SERIAL, TIMESTAMPTZ, without much explanation of why that type and not another. It matters more than it looks. Pick a type that is too narrow and a perfectly valid value gets rejected, or worse, silently truncated.

Open the terminal, give this lesson a fresh database of its own, and connect to it as postgres (lesson 02 explains the sudo -u postgres) ...

Want to learn PostgreSQL Data Types in a real environment?

Click below, get a fresh Linux box with PostgreSQL ready to go, and work through Data Types hands-on with an AI tutor that knows your code.

Start this lessonData Types

What you'll learn

  • Integer and bigint
  • Numeric vs float
  • Text and varchar
  • Boolean
  • Timestamptz vs timestamp
  • Date
  • Uuid
  • Json vs jsonb preview
  • Pg_typeof

Read this lesson in your language

All lessons in this course

14 lessons
  1. 1What is PostgreSQL20 min
  2. 2psql and First Commands25 min
  3. 3Creating Databases and Tables30 min
  4. 4Data Types25 min
  5. 5SELECT and WHERE30 min
  6. 6Joins35 min
  7. 7Aggregates and Grouping30 min
  8. 8Indexes35 min
  9. 9Transactions and Isolation35 min
  10. 10Functions and Triggers35 min
  11. 11JSONB and Arrays35 min
  12. 12EXPLAIN and Query Tuning35 min
  13. 13Backup and Restore25 min
  14. 14Capstone: Design a Schema60 min

Explore other courses

Data Types - PostgreSQL (English) | Engineering Courses