PG_FOREIGN_SERVER

Updated on 2024-09-30 GMT+08:00

View PDF

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	N/A	Row identifier (hidden attribute; displayed only when explicitly selected)
srvname	name	N/A	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	N/A	Type of the server (optional)
srvversion	text	N/A	Version of the server (optional)
srvacl	aclitem[]	N/A	Access permissions
srvoptions	text[]	N/A	Option used for foreign servers. It is a keyword=value string.