pg_foreign_server

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.

Table 1. pg_catalog.pg_foreign_server
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 GRANT and REVOKE for details.
srvoptions text[]   Foreign server-specific options, as "keyword=value" strings.