Say I have a table, say
project_data with lots of rows where the data may be grouped by a
project_id integer column, and partition it onto one table for each
Do I then need the
project_id column in every partition table, when the value is implicit?
It seems that having an extra column in project_data_5
project_id integer not null default 5 would be redundant as it will never have a value other than 5 in that table.
This is for postgresql 10.