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

Add a new column to an existing table

SQL

ALTER TABLE employees 
ADD COLUMN phone_number VARCHAR(20);

Tested against PostgreSQL 16

Note

“Adds a new column. Existing rows will have NULL for this column.