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

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; see Section 5.7 for details
`srvoptions` `text[]` Foreign server specific options, as “[.quote]#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; see Section 5.7 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

Submit correction

If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.

PostgreSQL

51.24. pg_foreign_server

Submit correction

51.24. `pg_foreign_server`