PostgreSQL

PostgreSQL Elephant Logo

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

oid

oid

Row identifier

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

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.

Copyright © 1996-2023 The PostgreSQL Global Development Group