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.