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.