Postgres 10

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version

PostgreSQL 10.23 (Debian 10.23-9.pgdg11+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 10.2.1-6) 10.2.1 20210110, 64-bit

SELECT 1

-- declarative partitioning arrived in PostgreSQL 10
create table measure (city text, taken date, degrees int) partition by list (city);
create table measure_york partition of measure for values in ('york');
create table measure_bath partition of measure for values in ('bath');

insert into measure values ('york','2026-01-01',4),('bath','2026-01-02',7);

CREATE TABLE

CREATE TABLE

CREATE TABLE

INSERT 0 2

select tableoid::regclass as partition, city, degrees
from measure
order by city;

partition
city
degrees

measure_bath
bath
7

measure_york
york
4

SELECT 2