Local parent table and Foreign table(s) as partition(s), is it possible?

Sbob <sbob@xxxxxxxxxxxxxxxxxxxxx> · Wed, 14 Sep 2022 11:41:24 -0600



    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.)