how to add new column to partitioned tables in postgres

user_5777936 0
Viewed 4268

I have created a new master table with multiple partitions on basis of a column value using declarative partitioning of postgres 10. How can i add new columns to the tables?

partitioning ddl postgresql
1 Answers

You only need to add that column to the base table: 

alter table master_table add new_column integer;

All partitions will automatically get that new column.

user_3303150
Related