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.

Table pg_foreign_server Columns

Column Type Description

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;
`srvoptions` `text[]` Foreign server specific options, as “keyword=value” strings

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;

srvoptions text[]

Foreign server specific options, as “keyword=value” strings

pg_foreign_server

pg_foreign_server

On this page

`pg_foreign_server`