_PG_FOREIGN_SERVERS
Displays information about a foreign server, as described in Table 1. Only the sysadmin user has the permission to view this view.
Name |
Type |
Description |
---|---|---|
oid |
oid |
OID of the foreign server |
srvoptions |
text[] |
Foreign server specific options, expressed in a string in the format of keyword=value |
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 |
foreign_data_wrapper_catalog |
information_schema.sql_identifier |
Name of the database where the foreign-data wrapper is located (always the current database) |
foreign_data_wrapper_name |
information_schema.sql_identifier |
Name of the foreign-data wrapper |
foreign_server_type |
information_schema.character_data |
Type of the foreign server |
foreign_server_version |
information_schema.character_data |
Version of the foreign server |
authorization_identifier |
information_schema.sql_identifier |
Role of the owner of the foreign server |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.