NAME

       ALTER_FOREIGN_TABLE - change the definition of a foreign table

SYNOPSIS

       ALTER FOREIGN TABLE [ IF EXISTS ] name
           action [, ... ]
       ALTER FOREIGN TABLE [ IF EXISTS ] name
           RENAME [ COLUMN ] column_name TO new_column_name
       ALTER FOREIGN TABLE [ IF EXISTS ] name
           RENAME TO new_name
       ALTER FOREIGN TABLE [ IF EXISTS ] name
           SET SCHEMA new_schema

       where action is one of:

           ADD [ COLUMN ] column_name data_type [ NULL | NOT NULL ]
           DROP [ COLUMN ] [ IF EXISTS ] column_name [ RESTRICT | CASCADE ]
           ALTER [ COLUMN ] column_name [ SET DATA ] TYPE data_type
           ALTER [ COLUMN ] column_name { SET | DROP } NOT NULL
           ALTER [ COLUMN ] column_name SET STATISTICS integer
           ALTER [ COLUMN ] column_name SET ( attribute_option = value [, ... ] )
           ALTER [ COLUMN ] column_name RESET ( attribute_option [, ... ] )
           ALTER [ COLUMN ] column_name OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ])
           OWNER TO new_owner
           OPTIONS ( [ ADD | SET | DROP ] option ['value'] [, ... ])

DESCRIPTION

           Note

           The following description applies only to Postgres-XC

       FOREIGN DATA WRAPPER has not been supported by Postgres-XC yet. This command may be supported in the
       future releases.

Postgres-XC 1.1                                    2014-04-07                             ALTER FOREIGN TABLE(7)