PG_FOREIGN_TABLE
PG_FOREIGN_TABLE records auxiliary information about foreign tables.
Table 1 PG_FOREIGN_TABLE columns
Name
|
Type
|
Description
|
|---|
ftrelid
|
oid
|
ID of a foreign table
|
ftserver
|
oid
|
Server where a foreign table is located
|
ftwriteonly
|
Boolean
|
Specifies whether data can be written in a foreign table. Value range:
- t (true): yes
- f (false): no
|
ftoptions
|
text[]
|
Options of a foreign table. For details, see the description of CREATE FOREIGN TABLE.
|