Object Oriented

CREATE TABLE cities (
  name       text,
  population real,
  elevation  int     -- (in ft)
);

CREATE TABLE capitals (
  state      char(2) UNIQUE NOT NULL
) INHERITS (cities);

Queries all cities including captials

SELECT name, elevation
  FROM cities
  WHERE elevation > 500;

To exclude captials

SELECT name, elevation
    FROM ONLY cities
    WHERE elevation > 500;

Last updated on June 10, 2026

Keys Partitions