PG_FOREIGN_SERVER
PG_FOREIGN_SERVER records the 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 | N/A | Row identifier (hidden attribute; displayed only when explicitly selected) |
srvname | Name | N/A | Name of the foreign server |
srvowner | OID | PG_AUTHID.oid | Owner of the foreign server |
srvfdw | OID | OID of the foreign-data wrapper of this foreign server | |
srvtype | Text | N/A | Type of the server (optional) |
srvversion | Text | N/A | Version of the server (optional) |
srvacl | aclitem[] | N/A | Access permissions |
srvoptions | Text[] | N/A | Option used for foreign servers. It is a keyword=value string. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
