From: | legrand legrand <legrand_legrand(at)hotmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | declarative partition by list, "other values" syntax |
Date: | 2017-11-20 20:52:48 |
Message-ID: | 1511211168922-0.post@n3.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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_data_part_a PARTITION OF wiki_data_part
FOR VALUES IN ('ang.q','ace.mw', ...);
CREATE TABLE wiki_data_part_b PARTITION OF wiki_data_part
FOR VALUES IN ('bs.s','bh.mw','bar','br.d', ...);
How could I create a partition containing the other values (like MINVALUE,
MAXVALUE for range partition) ?
CREATE TABLE wiki_data_part_others PARTITION OF wiki_data_part
FOR VALUES IN (others);
could not find it in doc
https://www.postgresql.org/docs/10/static/sql-createtable.html
Thanks in advance
Regards
PAscal
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html
From | Date | Subject | |
---|---|---|---|
Next Message | Magnus Hagander | 2017-11-20 20:54:25 | Re: To all who wish to unsubscribe |
Previous Message | Alvaro Herrera | 2017-11-20 20:52:40 | Re: To all who wish to unsubscribe |