The pg_foreign_server catalog provides information about foreign server definitions.
| Column name | Data type | Description |
|---|---|---|
oid |
oid |
A row identifier. |
srvname |
name |
The name of the foreign server. |
srvowner |
oid (references pg_authid.oid) |
The OID of the role that owns the foreign server. |
srvfdw |
oid (references pg_foreign_data_wrapper.oid) |
The OID of the foreign-data wrapper associated with this foreign server. |
srvtype |
text |
The type of the server (optional). |
srvversion |
text |
The version of the server (optional). |
srvacl |
aclitem[] |
Access privileges for the foreign server. |
srvoptions |
text[] |
Foreign server–specific options, expressed as “keyword=value” strings. |