Vol. I · A Postgres HandbookTwelve chapters · · 756 queries

The Query & the Schema

A reading-room reference for writing PostgreSQL by hand — selects to window functions, with the schema in plain view.

EasyBasic SELECT

DDL Practice: Create table variant #1

SQL

CREATE TABLE IF NOT EXISTS practice_table_1 (
  id SERIAL PRIMARY KEY,
  data_value VARCHAR(100),
  created_at TIMESTAMP DEFAULT NOW()
);

Tested against PostgreSQL 16

Note

“Basic table creation syntax pattern #1. Notice the use of SERIAL for auto-incrementing.