This page in other versions: 9.3 / 9.4 / 9.5 / 9.6 / current (10)  |  Development versions: devel / 11  |  Unsupported versions: 9.1 / 9.2

45.24. 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 45-24. 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 "keyword=value" strings
Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group