pg_foreign_table

`pg_foreign_table`

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 pg_foreign_table Columns

Column Type Description

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

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

pg_foreign_table

pg_foreign_table

On this page

`pg_foreign_table`