pg_foreign_server
pg_foreign_server#
The system catalog table pg_foreign_server
stores foreign server definitions. A foreign server describes a source of external data, such as a remote server. You access a foreign server via a foreign-data wrapper.
column |
type |
references |
description |
---|---|---|---|
|
oid |
The object ID |
|
|
name |
Name of the foreign server |
|
|
oid |
pg_authid.oid |
Owner of the foreign server |
|
oid |
pg_foreign_data_wrapper.oid |
OID of the foreign-data wrapper of this foreign server |
|
text |
Type of server (optional) |
|
|
text |
Version of the server (optional) |
|
|
aclitem[] |
Access privileges; see GRANT and REVOKE for details |
|
|
text[] |
Foreign server-specific options, as “keyword=value” string |