pg_foreign_server
The system catalog table pg_foreign_server stores foreign server definitions.
A foreign server describes a source of external data, such as a remote server.
You access a foreign server via a foreign data wrapper.
| Column | Type | References | Description |
|---|---|---|---|
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 server (optional) |
srvversion |
text |
— |
Version of the server (optional) |
srvacl |
aclitem[] |
— |
Access privileges (see Roles and privileges) |
srvoptions |
text[] |
— |
Foreign server-specific options, as |