Supported Versions: Current (13) / 12 / 11 / 10 / 9.6 / 9.5
Development Versions: devel
Unsupported versions: 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4
This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.

45.21. pg_foreign_server

The catalog pg_foreign_server stores foreign server definitions. A foreign server describes the connection to a remote server, managing external data. Foreign servers are accessed via foreign-data wrappers.

Table 45-21. pg_foreign_server Columns

Name 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 The 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