52.24. pg_foreign_server

pg_foreign_server

The catalog pg_foreign_server stores foreign server definitions. A foreign server describes a source of external data, such as a remote server. Foreign servers are accessed via foreign-data wrappers.

Column Type Description
oid `oid` Row identifier
srvname `name` Name of the foreign server
srvowner `oid` (references pg_authid.oid) Owner of the foreign server
srvfdw `oid` (references pg_foreign_data_wrapper.oid) 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 Privileges for details
srvoptions `text[]` Foreign server specific options, as "keyword=value" strings

Column Type

Description

oid oid

Row identifier

srvname name

Name of the foreign server

srvowner oid (references pg_authid.oid)

Owner of the foreign server

srvfdw oid (references pg_foreign_data_wrapper.oid)

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 Privileges for details

srvoptions text[]

Foreign server specific options, as "keyword=value" strings

: pg_foreign_server Columns