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 PG 18 manual ↗

The catalog pg_foreign_table contains auxiliary information about foreign tables.

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

Columns 3

ColumnTypeDescription / reference
ftrelidoidThe OID of the pg_class entry for this foreign table
pg_class.oid
ftserveroidOID 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. PG 13 → 14changed
  2. PG 9.6 → 10changed
  3. PG 9.0 → 9.1added

Definition snapshot: english-manuals:84be2e150ba68142360e3732bce… · English manual source