All;
I see the below options in the CREATE FOREIGN TABLE, however I assume these would both connect to a master/parent table on the foreign server. Is it possible to have a Foreign Table that acts as a partition of a local parent table, via either method (INHERITS or PARTITION OF)?
Thanks in advance...
INHERITS ( parent_table
[, ... ] )
The optional INHERITS
clause specifies a list of tables from which the new foreign table automatically inherits all columns. Parent tables can be plain tables or foreign tables. See the similar form of CREATE TABLE
for more details.
PARTITION OF parent_table
{ FOR VALUES partition_bound_spec
| DEFAULT }
This form can be used to create the foreign table as partition of the given parent table with specified partition bound values. See the similar form of CREATE TABLE
for more details. Note that it is currently not allowed to create the foreign table as a partition of the parent table if there are UNIQUE
indexes on the parent table. (See also ALTER TABLE ATTACH PARTITION
.)