tencent cloud

TencentDB for PostgreSQL

ドキュメントTencentDB for PostgreSQLUser GuideExtension ManagementExtension Overview

Extension Overview

Download
フォーカスモード
フォントサイズ
最終更新日: 2026-05-15 10:27:13
This document introduces information about the plugins supported by TencentDB for PostgreSQL.

Extension Overview

TencentDB for PostgreSQL supports a variety of open-source and self-developed plugins. These plugins can enhance capabilities in multiple areas, including instance Ops ease of use, query and write performance, full-text search, data search, and incremental data migration.

Using Extension

TencentDB for PostgreSQL already supports most commonly used plugins, which can be used directly. However, enabling some plugins requires specifying a particular version or special permissions. To enable these plugins, submit a ticket to contact our staff and provide your instance ID and the plugin name.

Creating Extension

When creating a plugin, the current pg_tencentdb_superuser is temporarily elevated to superuser to pass all permission checks. In PostgreSQL, plugins are managed at the database level. Different plugins can be created in different databases, and they cannot be used across databases. To create a plugin, access the target database using a client tool and execute the following statement to create the specified plugin:
CREATE EXTENSION [ IF NOT EXISTS ] extension_name
[ WITH ]
[ SCHEMA schema_name ]
[ VERSION version ]
[ FROM old_version ]

Viewing Created Extension

To view the list of plugins installed in the current database after some plugins have been installed, use the following command:
If you are using the psql client, you can execute the \\dx command.
\\dx
                                        List of installed extensions
     Name      | Version |   Schema   |                             Description                             
---------------+---------+------------+---------------------------------------------------------------------
 amcheck       | 1.2     | public     | functions for verifying relation integrity
 bloom         | 1.0     | public     | bloom access method - signature file based index
 hstore        | 1.6     | public     | data type for storing sets of (key, value) pairs
 hstore_plperl | 1.0     | public     | transform between hstore and plperl
 jsonb_plperl  | 1.0     | public     | transform between jsonb and plperl
 plperl        | 1.0     | pg_catalog | PL/Perl procedural language
 plpgsql       | 1.0     | pg_catalog | PL/pgSQL procedural language
 postgis       | 3.0.2   | public     | PostGIS geometry, geography, and raster spatial types and functions
(8 rows)
To view the list using SQL, execute the select * from pg_available_extensions where installed_version is not null; statement.
        name      | default_version | installed_version |                               comment                               
---------------+-----------------+-------------------+---------------------------------------------------------------------
 plperl        | 1.0             | 1.0               | PL/Perl procedural language
 amcheck       | 1.2             | 1.2               | functions for verifying relation integrity
 hstore_plperl | 1.0             | 1.0               | transform between hstore and plperl
 plpgsql       | 1.0             | 1.0               | PL/pgSQL procedural language
 jsonb_plperl  | 1.0             | 1.0               | transform between jsonb and plperl
 hstore        | 1.6             | 1.6               | data type for storing sets of (key, value) pairs
 bloom         | 1.0             | 1.0               | bloom access method - signature file based index
 postgis       | 3.0.2           | 3.0.2             | PostGIS geometry, geography, and raster spatial types and functions
(8 rows)

List of Supported Extensions

TencentDB for PostgreSQL already supports a variety of powerful and high-performance plugins. For the detailed list of plugins supported by each database edition, see Supported Plugin Edition Overview.
前の記事へ: Backup Recovery for Deleted Instances次の記事へ: Instructions About Plugin Limitations on Creating

ヘルプとサポート

この記事はお役に立ちましたか？

フィードバック