Help Center > > Developer Guide> System Catalogs and System Views> System Catalogs> PG_FOREIGN_SERVER

PG_FOREIGN_SERVER

Updated at: May 15, 2019 GMT+08:00

PG_FOREIGN_SERVER records the 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 1 PG_FOREIGN_SERVER columns

Name

Type

Reference

Description

oid

oid

-

Column 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

-

Type of the server (optional)

srvacl

aclitem[]

-

Access permissions

srvoptions

text[]

-

Option used for foreign servers. It is a keyword=value string.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel