This page in other versions: 9.1 / 9.2 / 9.3 / 9.4  |  Development versions: devel

48.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 48-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 "keyword=value" strings

Add Comment

Please use this form to add your own comments regarding your experience with particular features of PostgreSQL, clarifications of the documentation, or hints for other users. Please note, this is not a support forum, and your IP address will be logged. If you have a question or need help, please see the faq, try a mailing list, or join us on IRC. Note that submissions containing URLs or other keywords commonly found in 'spam' comments may be silently discarded. Please contact the webmaster if you think this is happening to you in error.

Proceed to the comment form.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group