Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-8.x)/ Schemas/ Information Schema/ _PG_FOREIGN_TABLE_COLUMNS
Updated on 2025-08-19 GMT+08:00
View PDF

_PG_FOREIGN_TABLE_COLUMNS

Displays column information about a foreign table, as described in Table 1. Only the sysadmin user has the permission to view this view.

Table 1 _PG_FOREIGN_TABLE_COLUMNS columns

Name

Type

Description

nspname

name

Schema name.

relname

name

Table name.

attname

name

Column name.

attfdwoptions

text[]

Attribute-level foreign data wrapper options, expressed in a string in the format of keyword=value.
Parent topic: Information Schema