Are you an LLM? You can read better optimized documentation at /en/docs/latest-lite/sql_reference/_pg_foreign_tables.md for this page in Markdown format
_PG_FOREIGN_TABLES
_PG_FOREIGN_TABLES stores information about all foreign tables defined in the current database, 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 |