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

oid

oid

The object ID

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 GRANT and REVOKE for details

srvoptions

text[]

Foreign server-specific options, as “keyword=value” string