pg_foreign_serverThe catalog pg_foreign_server stores 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.
Table 52.24. pg_foreign_server Columns
| Name | Type | References | Description |
|---|---|---|---|
oid |
oid |
Row identifier (hidden attribute; must be explicitly selected) | |
srvname |
name |
Name of the foreign server | |
srvowner |
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 privileges; see GRANT and REVOKE for details | |
srvoptions |
text[] |
Foreign server specific options, as “keyword=value” strings |