Re: declarative partition by list, "other values" syntax

2017-11-26 Thread legrand legrand
Found it in pg 11devel: CREATE TABLE wiki_data_part_a PARTITION OF wiki_data_part DEFAULT; -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

declarative partition by list, "other values" syntax

2017-11-20 Thread legrand legrand
Hello, I was trying to create a partitionned table by list, that has on special partition for "other values" for exemple create table wiki_data_part( category varchar(20), tim_id bigint, pag_id bigint, requests int, size bigint ) PARTITION BY LIST (category ); CREATE TABLE wiki_d