tencent cloud

Feedback

Extension Overview

Last updated: 2022-02-28 19:31:46

    This document describes the extensions supported by TencentDB for PostgreSQL.

    Extension Overview

    TencentDB for PostgreSQL supports multiple open-source and proprietary extensions. They help you perform instance OPS easier and improve the query and write performance as well as various capabilities such as token query, data retrieval, and incremental data migration.

    Using Extension

    Currently, TencentDB for PostgreSQL supports most common extensions for direct use. However, to enable certain extensions, you need to use specified versions or get special permissions. In this case, submit a ticket and provide the instance ID and extension name to enable it.

    Creating Extension

    When creating an extension, the pg_tencentdb_superuser is temporarily escalated to superuser and passes all permission checks.
    TencentDB for PostgreSQL extensions are managed at the database level. You can create different extensions for different databases, but databases cannot use extensions in other databases.
    To create an extension, access the database with the client tool and run the following statements:

    CREATE EXTENSION [ IF NOT EXISTS ] extension_name
    [ WITH ]
    [ SCHEMA schema_name ]
    [ VERSION version ]
    [ FROM old_version ]
    

    Viewing Created Extension

    If you have installed extensions, you can run the following command to view the list of extensions installed in the current database:

    • You can run the \dx command if you use the psql client.
    \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)
    
    • If you want to use SQL statements to view the extensions, run the select * from pg_available_extensions where installed_version is not null; statement to view the list of installed extensions.
          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 supports multiple powerful and high-performance extensions. For the list of extensions supported by each database version, see Supported Extensions.

    Contact Us

    Contact our sales team or business advisors to help your business.

    Technical Support

    Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

    7x24 Phone Support