Re: Question about partition exchange

From: legrand legrand <legrand_legrand(at)hotmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Question about partition exchange
Date: 2017-12-06 19:39:38
Message-ID: 1512589178777-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Garry Chen 2017-12-11 15:54:12 Question about alter table rename
Previous Message Garry Chen 2017-12-06 18:55:11 Question about partition exchange