PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

SYSTEM CATALOGS / SYSTEM CATALOGS

pg_foreign_server

Read PG 18 manual ↗

The catalog pg_foreign_server stores foreign server definitions.

Kind: System catalogs
Columns in this snapshot: 8
Definition source: English manual

Columns 8

Column	Type	Description / reference
`oid`	`oid`	Row identifier
`srvname`	`name`	Name of the foreign server
`srvowner`	`oid`	Owner of the foreign server pg_authid.oid
`srvfdw`	`oid`	OID of the foreign-data wrapper of this foreign server pg_foreign_data_wrapper.oid
`srvtype`	`text`	Type of the server (optional)
`srvversion`	`text`	Version of the server (optional)
`srvacl`	`aclitem[]`	Access privileges; see Section 5.8 for details
`srvoptions`	`text[]`	Foreign server specific options, as “keyword=value” strings

Column history across versions

Column	9.0	9.1	9.2	9.3	9.4	9.5	9.6	10	11	12	13	14	15	16	17	18	19	20
`oid`	·	·	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`srvname`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`srvowner`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`srvfdw`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`srvtype`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`srvversion`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`srvacl`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`srvoptions`	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●

Version history 6

Definition snapshot: english-manuals:b5b7d940d380a857a59bed2e779… · English manual source