Postgresql 中文操作指南

53.24. pg_foreign_server #

编目 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 53.24. pg_foreign_server Columns

Table 53.24. pg_foreign_server Columns

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 “keyword=value” strings