Vol. I · A Postgres Handbook

The Query & the Schema

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

IntermediateAdvanced PostgreSQL

Theory: What is a Schema?

The query

SQL
-- Q: What is a schema in PostgreSQL?
-- A: A schema is a namespace that contains named database objects 
-- (tables, views, functions). Every database can have multiple schemas. 
-- The default schema is called "public".
-- Unlike MySQL (where Database and Schema are synonymous), in PostgreSQL, 
-- a Database contains Schemas, which contain Tables.
Tested against PostgreSQL 16

Note

“Useful for multi-tenant applications (one schema per tenant).