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: PostgreSQL vs MySQL - Table Inheritance

The query

SQL
-- Q: Does MySQL support Table Inheritance?
-- A: No. Table Inheritance is an Object-Relational feature unique to 
-- PostgreSQL. You can create a table that inherits all columns from a 
-- parent table. Querying the parent table automatically includes rows 
-- from all child tables unless ONLY is used.
Tested against PostgreSQL 16

Note

“Historically used for partitioning, but declarative partitioning (PostgreSQL 10+) is now the standard.