Skip to content

Instantly share code, notes, and snippets.

View piotrwlodarczyk's full-sized avatar

piotrwlodarczyk

View GitHub Profile
CREATE TABLE "public.book_1-1000" PARTITION OF public.book FOR VALUES FROM ('1') TO ('1000') PARTITION BY RANGE (added);
CREATE TABLE "public.book_1-1000_1990-01-01" PARTITION OF "public.book_1-1000" FOR VALUES FROM ('1990-01-01') TO ('1990-04-01');
CREATE TABLE "public.book_1-1000_1990-04-01" PARTITION OF "public.book_1-1000" FOR VALUES FROM ('1990-04-01') TO ('1990-07-01');
CREATE TABLE "public.book_1-1000_1990-07-01" PARTITION OF "public.book_1-1000" FOR VALUES FROM ('1990-07-01') TO ('1990-10-01');
CREATE TABLE "public.book_1-1000_1990-10-01" PARTITION OF "public.book_1-1000" FOR VALUES FROM ('1990-10-01') TO ('1991-01-01');
CREATE TABLE "public.book_1-1000_1991-01-01" PARTITION OF "public.book_1-1000" FOR VALUES FROM ('1991-01-01') TO ('1991-04-01');
CREATE TABLE "public.book_1-1000_1991-04-01" PARTITION OF "public.book_1-1000" FOR VALUES FROM ('1991-04-01') TO ('1991-07-01');
CREATE TABLE "public.book_1-1000_1991-07-01" PARTITION OF "public.book_1-1000" FOR VALUES FROM ('1991-07-01') TO ('1991-10