_PG_FOREIGN_TABLES

Stores information about all foreign tables defined in the current database, as described in Table 1, whereas displays information about foreign tables accessible to the current user. Only the sysadmin user has the permission to view this view.

**Table 1** _PG_FOREIGN_TABLES columns
Name	Type	Description
foreign_table_catalog	information_schema.sql_identifier	Name of the database where the foreign table is located (always the current database).
foreign_table_schema	name	Name of the schema that the foreign table is in.
foreign_table_name	name	Name of the foreign table.
ftoptions	text[]	Foreign table options.
foreign_server_catalog	information_schema.sql_identifier	Name of the database where the foreign server is located (always the current database).
foreign_server_name	information_schema.sql_identifier	Name of the foreign server.
authorization_identifier	information_schema.sql_identifier	Role of the owner.