Help Center/ GaussDB/ Distributed_8.x/ Schemas/ Information Schema/ _PG_FOREIGN_DATA_WRAPPERS

Updated on 2024-06-03 GMT+08:00

View PDF

_PG_FOREIGN_DATA_WRAPPERS

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

**Table 1** _PG_FOREIGN_DATA_WRAPPERS columns
Name	Type	Description
oid	oid	OID of the foreign-data wrapper.
fdwowner	oid	OID of the owner of the foreign-data wrapper.
fdwoptions	text[]	Foreign-data wrapper specific option, expressed in a string in the format of keyword=value.
foreign_data_wrapper_catalog	information_schema.sql_identifier	Name of the database where the foreign-data wrapper is located (always the current database).
foreign_data_wrapper_name	information_schema.sql_identifier	Name of the foreign-data wrapper.
authorization_identifier	information_schema.sql_identifier	Role of the owner of the foreign-data wrapper.
foreign_data_wrapper_language	information_schema.character_data	Programming language of the foreign-data wrapper.