53.24. 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.

Table 53.24. pg_foreign_server Columns

Column Type

Description

oidoid

Row identifier

srvnamename

Name of the foreign server

srvowneroid (references pg_authid.oid)

Owner of the foreign server

srvfdwoid (references pg_foreign_data_wrapper.oid)

OID of the foreign-data wrapper of this foreign server

srvtypetext

Type of the server (optional)

srvversiontext

Version of the server (optional)

srvaclaclitem[]

Access privileges; see Section 5.7 for details

srvoptionstext[]

Foreign server specific options, as keyword=value strings


close