CREATE TABLE with PostgreSQL types - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does the CREATE TABLE statement do in PostgreSQL?

It creates a new table in the database where you can store data in rows and columns.

beginner

Name three common PostgreSQL data types used when creating a table.

Some common types are INTEGER for whole numbers, TEXT for text strings, and BOOLEAN for true/false values.

intermediate

What is the difference between VARCHAR(n) and TEXT in PostgreSQL?

VARCHAR(n) limits the text length to n characters, while TEXT allows any length of text without a limit.

intermediate

How do you define a column that automatically increases its value for each new row in PostgreSQL?

Use the SERIAL type, which creates an auto-incrementing integer column.

beginner

What PostgreSQL data type would you use to store date and time information?

You can use DATE for dates, TIME for time of day, and TIMESTAMP for both date and time together.

Which PostgreSQL data type is best for storing true or false values?

A TEXT

B INTEGER

C BOOLEAN

D DATE

BOOLEAN stores true or false values, perfect for yes/no data.

What does the SERIAL type do in a PostgreSQL table?

A Limits text length

B Stores large text data

C Stores date and time

D Creates an auto-incrementing integer column

SERIAL automatically increases the integer value for each new row.

Which data type should you use to store a person's full name without length limit?

A TEXT

B VARCHAR(50)

C INTEGER

D BOOLEAN

TEXT allows storing text of any length.

How do you specify a column to store only date (no time) in PostgreSQL?

A DATE

B TIMESTAMP

C TIME

D BOOLEAN

DATE stores only the date part without time.

Which of these is NOT a valid PostgreSQL data type?

A INTEGER

B STRING

C TIMESTAMP

D BOOLEAN

STRING is not a PostgreSQL data type; use TEXT or VARCHAR instead.

Explain how to create a table in PostgreSQL with columns for an ID, name, and birth date using appropriate data types.

Think about what kind of data each column holds and pick the right type.

Describe the difference between VARCHAR(n) and TEXT types in PostgreSQL and when to use each.

Consider if you want to restrict how long the text can be.