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.

IntermediateBasic SELECT

Drop table safely

SQL

DROP TABLE IF EXISTS old_logs CASCADE;

Tested against PostgreSQL 16

Note

“CASCADE automatically drops objects that depend on the table (like views). IF EXISTS prevents errors if table is gone.