Help Center > > Developer Guide> System Catalogs and System Views> System Catalogs> PG_EXTENSION

PG_EXTENSION

Updated at: Jul 15, 2020 GMT+08:00

PG_EXTENSION records information about the installed extensions. By default, DWS has 12 extensions, that is, PLPGSQL, DIST_FDW, FILE_FDW, HDFS_FDW, HSTORE, PLDBGAPI, DIMSEARCH, PACKAGES, GC_FDW, UUID-OSSP, LOG_FDW, and ROACH_API.

Table 1 PG_EXTENSION

Name

Type

Description

extname

name

Extension name

extowner

oid

Owner of the extension

extnamespace

oid

Namespace containing the extension's exported objects

extrelocatable

Boolean

Whether the extension can be relocated to another namespace. true indicates that relocation is allowed.

extversion

text

Version number of the extension

extconfig

oid[]

Configuration information about the extension

extcondition

text[]

Filter conditions for the extension's configuration information

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel