51.24. pg_foreign_server
The 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 51.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 |
pg_authid.oid |
Owner of the foreign server |
srvfdw |
oid |
pg_foreign_data_wrapper.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 |
© 1996–2019 The PostgreSQL Global Development Group
Licensed under the PostgreSQL License.
https://www.postgresql.org/docs/10/catalog-pg-foreign-server.html