Version: latest

_PG_FOREIGN_TABLES ​

Stores information about all foreign tables defined in the current database. Only foreign tables that the current user has access privileges to are displayed. This view can only be viewed by users with sysadmin privileges.

Table 1 _PG_FOREIGN_TABLES fields

Name

Type

Description

foreign_table_catalog

information_schema.sql_identifier

Name of the database containing the foreign table (always the current database).

foreign_table_schema

name

Schema name of the foreign table.

foreign_table_name

name

Name of the foreign table.

ftoptions

text[]

Options of the foreign table.

foreign_server_catalog

information_schema.sql_identifier

Name of the database where the foreign server resides (always the current database).

foreign_server_name

information_schema.sql_identifier

Name of the foreign server.

authorization_identifier

information_schema.sql_identifier

Role name of the owner.