Postgres Pro
Downloads
Home   >   mailing lists

Re: Question about partition exchange - Mailing list pgsql-novice

From legrand legrand
Subject Re: Question about partition exchange
Date
Msg-id 1512589178777-0.post@n3.nabble.com
Whole thread Raw
In response to Question about partition exchange  (Garry Chen <gc92@cornell.edu>)
List pgsql-novice
Tree view 
Hello,
with pg10 you have syntax

ALTER TABLE year_total DETACH PARTITION year_total_2015;

ALTER TABLE year_total ATTACH PARTITION year_total_2015_new
    FOR VALUES ...

See https://www.postgresql.org/docs/current/static/ddl-partitioning.html

Regards
PAscal



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-novice-f2132464.html

pgsql-novice by date:

Previous
From: Garry Chen
Date:
Subject: Question about partition exchange
Next
From: Garry Chen
Date:
Subject: Question about alter table rename