Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-8.x)/ System Catalogs and System Views/ System Catalogs/ Other System Catalogs/ PG_FOREIGN_TABLE
Updated on 2025-08-19 GMT+08:00
View PDF

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 the foreign table is located.

ftwriteonly

boolean

Specifies whether the foreign table is writable. Values are as follows:

  • t (true): yes
  • f (false): no

ftoptions

text[]

Options of a foreign table. For details, see the description of CREATE FOREIGN TABLE.
Parent topic: Other System Catalogs