PG_FOREIGN_SERVER
PG_FOREIGN_SERVER records foreign server definitions. A foreign server describes a source of external data, such as a remote server. Foreign servers are accessed via foreign-data wrappers.
Name | Type | Reference | Description |
|---|---|---|---|
oid | oid | - | Row identifier (hidden attribute, which must be specified) |
srvname | name | - | Name of a foreign server |
srvowner | oid | oid in PG_AUTHID | Owner of the foreign server |
srvfdw | oid | oid in PG_FOREIGN_DATA_WRAPPER | OID of the foreign-data wrapper on this foreign server |
srvtype | text | - | Type of the server (optional) |
srvversion | text | - | Version of the server (optional) |
srvacl | aclitem[] | - | Access permissions |
srvoptions | text[] | - | Option used for foreign servers, expressed in a string in the format of keyword=value |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
