52.25. pg_foreign_table

52.25. `pg_foreign_table`
Prev	Up	Chapter 52. System Catalogs	Home	Next

The catalog pg_foreign_table contains auxiliary information about foreign tables. A foreign table is primarily represented by a pg_class entry, just like a regular table. Its pg_foreign_table entry contains the information that is pertinent only to foreign tables and not any other kind of relation.

Table 52.25. pg_foreign_table Columns

Column Type Description
`ftrelid` `oid` (references `pg_class` . `oid` ) The OID of the `pg_class` entry for this foreign table
`ftserver` `oid` (references `pg_foreign_server` . `oid` ) OID of the foreign server for this foreign table
`ftoptions` `text[]` Foreign table options, as " keyword=value " strings

Column Type

Description

ftrelid oid (references pg_class . oid )

The OID of the pg_class entry for this foreign table

ftserver oid (references pg_foreign_server . oid )

OID of the foreign server for this foreign table

ftoptions text[]

Foreign table options, as " keyword=value " strings

Prev	Up	Next
52.24. `pg_foreign_server`	Home	52.26. `pg_index`