PostgreSQL

51.24. `pg_foreign_server`
Prev	Up	Chapter 51. System Catalogs	Home	Next

51.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 51.24. pg_foreign_server Columns

Name Type References Description

Name	Type	References	Description
`oid`	`oid`		Row identifier (hidden attribute; must be explicitly selected)
`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 the 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 “[.quote]#keyword=value”# strings

oid

Row identifier (hidden attribute; must be explicitly selected)

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 the 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 “[.quote]#keyword=value”# strings

Prev	Up	Next
51.23. `pg_foreign_data_wrapper`	Home	51.25. `pg_foreign_table`

51.23. pg_foreign_data_wrapper

Home

51.25. pg_foreign_table

PostgreSQL

51.24. pg_foreign_server

51.24. `pg_foreign_server`