Are you an LLM? You can read better optimized documentation at /en/docs/latest/sql_reference/_pg_foreign_tables.md for this page in Markdown format
_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. |