Available Extensions
Installing an Extension
To install an extension, open the psql terminal and run:
CREATE EXTENSION <extension name>;
Note that you will need to be authenticated as a user with CREATE permissions, on the database that you install the extension into. For further details, see the official documentation.
Available Extensions
The following extensions are supported and available for installation on your Instaclustr-managed Postgresql cluster:
- Btree_gin
Provides sample GIN operator classes that implement B-tree equivalent behavior - Btree_gist
Provides GiST index operator classes that implement B-tree equivalent behavior - Citext
Provides a case-insensitive character string type, citext. Essentially, it internally calls lower when comparing values - Cube
Implements a data type cube for representing multidimensional cubes. - Dict_int
An example of an add-on dictionary template for full-text search - Fuzzystrmatch
Provides several functions to determine similarities and distance between strings - Hstore
Implements the hstore data type for storing sets of key/value pairs within a single PostgreSQL value - Intarray
Provides a number of useful functions and operators for manipulating null-free arrays of integers - Isn
Provides data types for the following international product numbering standards: EAN13, UPC, ISBN (books), ISMN (music), and ISSN (serials) - Lo
Provides support for managing Large Objects (also called LOs or BLOBs) - Ltree
Implements a data type ltree for representing labels of data stored in a hierarchical tree-like structure - Pgcrypto
Provides cryptographic functions for PostgreSQL - Pg_trgm
Provides functions and operators for determining the similarity of alphanumeric text based on trigram matching, as well as index operator classes that support fast searching for similar strings - Seg
Implements a data type seg for representing line segments, or floating point intervals - Tablefunc
Includes various functions that return tables (that is, multiple rows) - Tcn
Provides a trigger function that notifies listeners of changes to any table on which it is attached - Tsm_system_rows
Provides the table sampling method SYSTEM_ROWS, which can be used in the TABLESAMPLE clause of a SELECT command - Tsm_system_time
Provides the table sampling method SYSTEM_TIME, which can be used in the TABLESAMPLE clause of a SELECT command - Unaccent
Text search dictionary that removes accents (diacritic signs) from lexemes. - Uuid-ossp
Provides functions to generate universally unique identifiers (UUIDs) using one of several standard algorithms.
Requesting the Addition of an Extension
To request that other extensions be bundled with Instaclustr-managed PostgreSQL clusters, please raise a support request.
Need Support?
Experiencing difficulties on the website or console?
Already have an account?
Need help with your cluster?
Contact Support Why sign up?
Spin up a cluster in minutes