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

Parent topic: System Catalogs Definitions

check-circle-line exclamation-circle-line close-line
Scroll to top icon