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

Copyright © 1996-2023 The PostgreSQL Global Development Group