• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Systems Tables and Views
  5. PG_FOREIGN_SERVER

PG_FOREIGN_SERVER

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