Hi All,
Is there a way I can do partition exchange? For example, I have a year_total table and it is partitioned by year. I would like to exchange partition table year_total_2015 with year_total_2015_new. Any suggestions are welcome.
Thank you very much,
Garry
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
Соглашаюсь с условиями обработки персональных данных