Postgresql 中文操作指南

53.22. pg_extension #

目录_pg_extension_存储有关已安装扩展的信息。有关扩展的详细信息，请参见 Section 38.17。

The catalog pg_extension stores information about the installed extensions. See Section 38.17 for details about extensions.

Table 53.22. pg_extension Columns

Column Type

Description

oid oid

Row identifier

extname name

Name of the extension

extowner oid (references pg_authid.oid)

Owner of the extension

extnamespace oid (references pg_namespace.oid)

Schema containing the extension’s exported objects

extrelocatable bool

True if extension can be relocated to another schema

extversion text

Version name for the extension

extconfig oid[] (references pg_class.oid)

Array of regclass OIDs for the extension’s configuration table(s), or NULL if none

extcondition text[]

Array of WHERE-clause filter conditions for the extension’s configuration table(s), or NULL if none

注意，与带有 “namespace” 列的大多数目录不同，extnamespace 并不意味着扩展属于该模式。扩展名称永远不用模式限定。而是，extnamespace 指示包含扩展的大多数或全部对象的模式。如果 extrelocatable 为真，则此模式实际上必须包含属于该扩展的所有可模式限定对象。

Note that unlike most catalogs with a “namespace” column, extnamespace is not meant to imply that the extension belongs to that schema. Extension names are never schema-qualified. Rather, extnamespace indicates the schema that contains most or all of the extension’s objects. If extrelocatable is true, then this schema must in fact contain all schema-qualifiable objects belonging to the extension.