PostgreSQL

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

52.25. `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 52.25. 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 “[.quote]#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 “[.quote]#keyword=value”# strings

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

52.24. pg_foreign_server

Home

52.26. pg_index

Submit correction

If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.

PostgreSQL

52.25. pg_foreign_table

Submit correction

52.25. `pg_foreign_table`