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.

AdvancedBasic SELECT

Create table LIKE another table

SQL

CREATE TABLE employees_archive (LIKE employees INCLUDING ALL);

Tested against PostgreSQL 16

Note

“Copies structure. INCLUDING ALL copies constraints, indexes, defaults, and comments. Data is NOT copied.