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

Read the PG 18 manual

The catalog pg_foreign_table contains auxiliary information about foreign tables.

Reading PG 18current·documented in 17 of 24 versions, 9.1 to 20

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

Columns 3

As listed in the PostgreSQL 18 manual.

ColumnTypeDescription / reference
ftrelidoidNOT NULLThe OID of the pg_class entry for this foreign table
pg_class.oid
ftserveroidNOT NULLOID of the foreign server for this foreign table
pg_foreign_server.oid
ftoptionstext[]Foreign table options, as “keyword=value” strings
Column history across versions
Version history 3
  1. 13 → 14 reworded
  2. 9.6 → 10 reworded
  3. 9.0 → 9.1 added

Definition snapshot: english-manuals:7b23794ead20cc2f3bcbc177644… · English manual source