PostgreSQL 14 Documentation: 52.24. pg_foreign_server

52.24. `pg_foreign_server`
Prev	Up	Chapter 52. System Catalogs	Home	Next

52.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 52.24. pg_foreign_server Columns

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 Section 5.7 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 Section 5.7 for details

srvoptions text[]

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

Prev	Up	Next
52.23. `pg_foreign_data_wrapper`	Home	52.25. `pg_foreign_table`