↑↓ 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_data_wrapper

Read the PG 18 manual

The catalog pg_foreign_data_wrapper stores foreign-data wrapper definitions.

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

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

Columns 7

As listed in the PostgreSQL 18 manual.

ColumnTypeDescription / reference
oidoidNOT NULLRow identifier
fdwnamenameNOT NULLName of the foreign-data wrapper
fdwowneroidNOT NULLOwner of the foreign-data wrapper
pg_authid.oid
fdwhandleroidNOT NULLReferences a handler function that is responsible for supplying execution routines for the foreign-data wrapper. Zero if no handler is provided
pg_proc.oid
fdwvalidatoroidNOT NULLReferences a validator function that is responsible for checking the validity of the options given to the foreign-data wrapper, as well as options for foreign servers and user mappings using the foreign-data wrapper. Zero if no validator is provided
pg_proc.oid
fdwaclaclitem[]Access privileges; see Section 5.8 for details
fdwoptionstext[]Foreign-data wrapper specific options, as “keyword=value” strings
Column history across versions
Version history 6
  1. 18 → 19 changed
  2. 16 → 17 reworded
  3. 11 → 12 changed
  4. 9.6 → 10 reworded
  5. 9.0 → 9.1 changed
  6. 8.3 → 8.4 added

Definition snapshot: english-manuals:27f13e4e822c32216454f0f623a… · English manual source