--- title: "PostgreSQL® - Available extensions" description: "OVHcloud Databases for PostgreSQL® come with a set of supported extensions." url: https://docs.us.ovhcloud.com/en/public-cloud/databases/postgresql-available-extensions lang: en --- > For AI agents: the complete documentation index is available at https://docs.us.ovhcloud.com/en/llms.txt, the full documentation bundle is available at https://docs.us.ovhcloud.com/en/llms-full.txt. # PostgreSQL® - Available extensions ## List of available extensions OVHcloud Databases for PostgreSQL[®](#go-further) come with a set of supported extensions. You cannot install unsupported ones, since they are managed and industrialized services. Contact us if an extension is missing for your project, and we may consider the implementation. Please note that some of the extensions have dependencies and they need to be created in the proper order. Also, some extensions may require disconnecting the client and reconnecting before they are fully available.   ### Auditing | Extension Name | Reference | Notes | | -------------- | -------------------------------------------------------- | -------------------------------------------------------------------------------------------------------------------------- | | `pgaudit` | [Link](https://github.com/pgaudit/pgaudit) | Provides session and object audit logging, often required for compliance with government, financial, or ISO certifications | | `tcn` | [Link](https://www.postgresql.org/docs/current/tcn.html) | Triggered change notifications. |   ### Connectivity | Extension Name | Reference | Notes | | -------------- | ---------------------------------------------------------------------------- | -------------------------------------------------------------- | | `dblink` | [Link](https://www.postgresql.org/docs/current/contrib-dblink-function.html) | Connect to other PostgreSQL® databases from within a database. | | `postgres_fdw` | [Link](https://www.postgresql.org/docs/current/postgres-fdw.html) | Foreign-data wrapper for remote PostgreSQL® servers. |   ### Data types | Extension Name | Reference | Notes | | -------------- | -------------------------------------------------------------- | --------------------------------------------------------------------------------------------- | | `citext` | [Link](https://www.postgresql.org/docs/current/citext.html) | Data type for case-insensitive character strings. | | `cube` | [Link](https://www.postgresql.org/docs/current/cube.html) | Data type for multidimensional cubes. | | `hll` | [Link](https://github.com/citusdata/postgresql-hll) | Type for storing `hyperloglog` data. `PG11 and newer` | | `hstore` | [Link](https://www.postgresql.org/docs/current/hstore.html) | Data type for storing sets of (key, value) pairs. | | `isn` | [Link](https://www.postgresql.org/docs/current/isn.html) | Data types for international product numbering standards. | | `ltree` | [Link](https://www.postgresql.org/docs/current/ltree.html) | Data type for hierarchical tree-like structures. | | `seg` | [Link](https://www.postgresql.org/docs/current/seg.html) | Data type for representing line segments or floating-point intervals. | | `timescaledb` | [Link](https://github.com/timescale/timescaledb) | Enables scalable inserts and complex queries for time-series data. Not yet available on PG18. | | `unit` | [Link](https://github.com/df7cb/postgresql-unit) | SI units extension. | | `uuid-ossp` | [Link](https://www.postgresql.org/docs/current/uuid-ossp.html) | Generate universally unique identifiers (UUIDs). |   ### Geographical features | Extension Name | Reference | Notes | | ------------------------------ | ------------------------------------------------------------------ | --------------------------------------------------------------------------------------------------------------------------- | | `address_standardizer` | [Link](https://postgis.net/docs/standardize_address.html) | Used to parse an address into constituent elements. Generally used to support geocoding address normalization step. | | `address_standardizer_data_us` | [Link](https://postgis.net/docs/standardize_address.html) | Address standardizer US dataset example. | | `earthdistance` | [Link](https://www.postgresql.org/docs/current/earthdistance.html) | Calculate great-circle distances on the surface of the Earth. | | `h3` | [Link](https://github.com/zachasme/h3-pg) | PostgreSQL® bindings for H3, a hierarchical hexagonal geospatial indexing system. | | `h3_postgis` | [Link](https://github.com/zachasme/h3-pg) | H3 PostGIS integration. | | `pgrouting` | [Link](https://github.com/pgRouting/pgrouting) | Extends the PostGIS/PostgreSQL® geospatial database to provide geospatial routing and other network analysis functionality. | | `postgis` | [Link](https://postgis.net/) | PostGIS geometry and geography spatial types and functions. | | `postgis_legacy` | [Link](https://postgis.net/) | Legacy functions for PostGIS. | | `postgis_raster` | [Link](https://postgis.net/docs/RT_reference.html) | PostGIS raster types and functions. | | `postgis_sfcgal` | [Link](https://postgis.net/docs/reference_sfcgal.html) | PostGIS SFCGAL functions. | | `postgis_tiger_geocoder` | [Link](https://postgis.net/docs/Extras.html#Tiger_Geocoder) | PostGIS tiger geocoder and reverse geocoder. | | `postgis_topology` | [Link](https://postgis.net/docs/Topology.html) | PostGIS topology spatial types and functions. |   ### Machine learning (ML) and artificial intelligence (AI) | Extension Name | Reference | Notes | | --------------- | -------------------------------------------------- | ----------------------------------------------------------------------------------- | | `pgvector` | [Link](https://github.com/pgvector/pgvector) | Designed for vector similarity search for PostgreSQL®. `PG13 and newer` | | `pgvectorscale` | [Link](https://github.com/timescale/pgvectorscale) | Complements `pgvector` as a vector data extension for PostgreSQL®. `PG16 and newer` | **Note:** Supported `pgvectorscale` versions: - PG16: pgvectorscale-0.6.0 - PG17: pgvectorscale-0.6.0   ### Procedural language | Extension Name | Reference | Notes | | -------------- | ------------------------------------------------------------ | ----------------------------- | | `plperl` | [Link](https://www.postgresql.org/docs/current/plperl.html) | PL/Perl procedural language. | | `plpgsql` | [Link](https://www.postgresql.org/docs/current/plpgsql.html) | PL/pgSQL procedural language. |   ### Search and text handling | Extension Name | Reference | Notes | | --------------- | ------------------------------------------------------------------ | ------------------------------------------------------------------ | | `bloom` | [Link](https://www.postgresql.org/docs/current/bloom.html) | Bloom access method - signature file-based index. | | `btree_gin` | [Link](https://www.postgresql.org/docs/current/btree-gin.html) | Support for indexing common data types in GIN. | | `btree_gist` | [Link](https://www.postgresql.org/docs/current/btree-gist.html) | Support for indexing common data types in GiST. | | `dict_int` | [Link](https://www.postgresql.org/docs/current/dict-int.html) | Text search dictionary template for integers. | | `fuzzystrmatch` | [Link](https://www.postgresql.org/docs/current/fuzzystrmatch.html) | Determine similarities and distance between strings. | | `pg_similarity` | [Link](https://github.com/eulerto/pg_similarity) | Support similarity queries. `PG13 and newer` | | `pg_trgm` | [Link](https://www.postgresql.org/docs/current/pgtrgm.html) | Text similarity measurement and index searching based on trigrams. | | `pgcrypto` | [Link](https://www.postgresql.org/docs/current/pgcrypto.html) | Cryptographic functions. | | `rum` | [Link](https://github.com/postgrespro/rum) | RUM index access method. | | `unaccent` | [Link](https://www.postgresql.org/docs/current/unaccent.html) | Text search dictionary that removes accents. |   ### Utilities | Extension Name | Reference | Notes | | -------------------- | --------------------------------------------------------------------- | -------------------------------------------------------------------------------------------------------------------------- | | `aiven_extras` | [Link](https://github.com/aiven/aiven-extras) | This extension is meant for use in environments where you want non-superusers to be able to use certain database features. | | `bool_plperl` | [Link](https://www.postgresql.org/docs/current/plperl-funcs.html) | Transform between `bool` and `plperl`. `PG13 and newer` | | `intagg` | [Link](https://www.postgresql.org/docs/current/intagg.html) | Integer aggregator and enumerator (obsolete). | | `intarray` | [Link](https://www.postgresql.org/docs/current/intarray.html) | Functions, operators, and index support for 1-D arrays of integers. | | `jsonb_plperl` | [Link](https://www.postgresql.org/docs/current/datatype-json.html) | Transform between `jsonb` and `plperl`. | | `lo` | [Link](https://www.postgresql.org/docs/current/lo.html) | Large Object maintenance. | | `pageinspect` | [Link](https://www.postgresql.org/docs/current/pageinspect.html) | Inspect the contents of database pages at a low level. | | `pg_buffercache` | [Link](https://www.postgresql.org/docs/current/pgbuffercache.html) | Examine the shared buffer cache. | | `pg_cron` | [Link](https://github.com/citusdata/pg_cron) | Job scheduler for PostgreSQL®. | | `pg_partman` | [Link](https://github.com/pgpartman/pg_partman) | Extension to manage partitioned tables by time or ID. | | `pg_prewarm` | [Link](https://www.postgresql.org/docs/current/pgprewarm.html) | Prewarm relation data. PG11 and newer | | `pg_prometheus` | [Link](https://github.com/timescale/pg_prometheus) | Prometheus metrics for PostgreSQL®. `PG12 and earlier` | | `pg_repack` | [Link](https://pgxn.org/dist/pg_repack/1.4.6/) | Reorganize tables in PostgreSQL® databases with minimal locks. | | `pg_stat_statements` | [Link](https://www.postgresql.org/docs/current/pgstatstatements.html) | Track planning and execution statistics of all SQL statements executed. | | `pgrowlocks` | [Link](https://www.postgresql.org/docs/current/pgrowlocks.html) | Show row-level locking information. | | `pgstattuple` | [Link](https://www.postgresql.org/docs/current/pgstattuple.html) | Show tuple-level statistics. | | `sslinfo` | [Link](https://www.postgresql.org/docs/current/sslinfo.html) | Information about SSL certificates. | | `tablefunc` | [Link](https://www.postgresql.org/docs/current/tablefunc.html) | Functions that manipulate whole tables, including `crosstab`. | | `timetravel` | [Link](https://www.postgresql.org/docs/6.3/c0503.htm) | Functions for implementing time travel. `PG11 and earlier` | | `tsm_system_rows` | [Link](https://www.postgresql.org/docs/current/tsm-system-rows.html) | TABLESAMPLE method, which accepts number of rows as a limit. | | `tsm_system_time` | [Link](https://www.postgresql.org/docs/current/tsm-system-time.html) | TABLESAMPLE method, which accepts time in milliseconds as a limit. |   ## Installing an extension You can list available extensions: ```sql defaultdb=> SELECT * FROM pg_available_extensions; ``` ``` name | default_version | installed_version | comment ------------------------------+-----------------+-------------------+-------------------------------------------------------------------------------------------------------------------- address_standardizer | 3.2.4 | | Used to parse an address into constituent elements. Generally used to support geocoding address normalization step. address_standardizer_data_us | 3.2.4 | | Address Standardizer US dataset example aiven_extras | 1.1.8 | | aiven_extras aiven_gatekeeper | 1.0.0 | | Aiven standard security library [...] (71 rows) ``` Install an available extension: ```sql defaultdb=> CREATE EXTENSION IF NOT EXISTS ""; CREATE EXTENSION ``` Check installed extensions: ```sql defaultdb=> \dx ``` ``` List of installed extensions Name | Version | Schema | Description --------------+---------+--------------+------------------------------ aiven_extras | 1.1.8 | aiven_extras | aiven_extras pg_cron | 1.4-1 | public | Job scheduler for PostgreSQL plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language -- In this example, aiven_extras and pg_cron are installed. plpgsql is installed by default. ```   ## Go further Browse all the [Databases guides](https://docs.us.ovhcloud.com/en/public-cloud/databases/landing-page-databases.md). Browse the rest of the [OVHcloud US documentation](https://docs.us.ovhcloud.com/en/index.md) for guides on our other products and services. Learn more about [Managed Databases](https://us.ovhcloud.com/public-cloud/databases/) on the OVHcloud US website. OVHcloud Managed Databases and Analytics: - Grafana® is a registered trademark of Grafana Labs and is used with the permission of Grafana Labs. OVH SAS and its subsidiaries are not affiliated with or endorsed by Grafana Labs. - Kafka® is a registered trademark of The Apache Software Foundation and has been licensed for use by OVHcloud, who has no affiliation with and is not endorsed by The Apache Software Foundation. - MongoDB® is a registered trademark of MongoDB, Inc. - MySQL® is a registered trademark of Oracle and/or its affiliates. - PostgreSQL® is a registered trademark of the PostgreSQL Community Association of Canada.