PostgreSQL

53.25. `pg_foreign_table`
Prev	Up	Chapter 53. System Catalogs	Home	Next

53.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 53.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
53.24. `pg_foreign_server`	Home	53.26. `pg_index`

53.24. pg_foreign_server

Home

53.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

53.25. pg_foreign_table #

Submit correction

53.25. `pg_foreign_table` #