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 |
| Row identifier (hidden attribute; must be explicitly selected) |
srvname | name |
| 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 |
| Type of the server (optional) |
srvversion | text |
| Version of the server (optional) |
srvacl | aclitem[] |
| Access permissions |
srvoptions | text[] |
| Option used for foreign servers. It is a keyword=value string. |