↑↓ select ↵ open ⌫ change scope Open full search

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

System Catalogs / System catalogs

pg_foreign_server

Read the PG 18 manual

The catalog pg_foreign_server stores foreign server definitions.

Reading PG 18current·documented in 19 of 24 versions, 8.4 to 20

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

Columns 8

As listed in the PostgreSQL 18 manual.

ColumnTypeDescription / reference
oidoidNOT NULLRow identifier
srvnamenameNOT NULLName of the foreign server
srvowneroidNOT NULLOwner of the foreign server
pg_authid.oid
srvfdwoidNOT NULLOID of the foreign-data wrapper of this foreign server
pg_foreign_data_wrapper.oid
srvtypetextType of the server (optional)
srvversiontextVersion of the server (optional)
srvaclaclitem[]Access privileges; see Section 5.8 for details
srvoptionstext[]Foreign server specific options, as “keyword=value” strings
Column history across versions
Version history 7
  1. 18 → 19 reworded
  2. 16 → 17 reworded
  3. 11 → 12 changed
  4. 9.6 → 10 reworded
  5. 9.0 → 9.1 reworded
  6. 8.4 → 9.0 reworded
  7. 8.3 → 8.4 added

Definition snapshot: english-manuals:878739dd5489dec1ec19de79d57… · English manual source