The foreign_table_options view contains all of the options defined for foreign tables in the current database. Greenplum Database displays only those foreign tables to which the current user has access (by way of being the owner or having some privilege).

    columntypereferencesdescription
    foreign_table_catalogsql_identifier Name of the database in which the foreign table is defined (always the current database).
    foreign_table_schemasql_identifier Name of the schema that contains the foreign table.
    foreign_table_namesql_identifier Name of the foreign table.
    option_namesql_identifier Name of an option.
    option_valuecharacter_data Value of the option.

    Parent topic: System Catalogs Definitions