_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.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot