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.

EasyAdvanced PostgreSQL

Theory: What is PostgreSQL?

The query

SQL
-- Q: What is PostgreSQL?
-- A: PostgreSQL is an advanced, enterprise-class, open-source 
-- Object-Relational Database Management System (ORDBMS). 
-- It is known for its proven architecture, reliability, data integrity, 
-- robust feature set, and extensibility.
Tested against PostgreSQL 16

Note

“Unlike pure RDBMS, ORDBMS supports objects, classes, and inheritance directly in database schemas.