PostgreSQL

PostgreSQL Elephant Logo

51.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 51.25. pg_foreign_table Columns

Name Type References Description

ftrelid

oid

pg_class.oid

OID of the pg_class entry for this foreign table

ftserver

oid

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

51.24. pg_foreign_server

Home

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

Copyright © 1996-2023 The PostgreSQL Global Development Group