Extension versions

The following extensions are available for the Azure Database for the PostgreSQL service.

List of extensions

Below is the list of extensions available.

address_standardizer

address_standardizer is used to parse an address into constituent elements. Generally used to support geocoding address normalization step.

PostgreSQL version Extension version
PostgreSQL 16 3.3.3
PostgreSQL 15 3.3.1
PostgreSQL 14 3.2.3
PostgreSQL 13 3.2.3
PostgreSQL 12 3.2.3
PostgreSQL 11 3.2.3

address_standardizer_data_us

address_standardizer_data_us is the Address Standardizer US dataset example.

PostgreSQL version Extension version
PostgreSQL 16 3.3.3
PostgreSQL 15 3.3.1
PostgreSQL 14 3.2.3
PostgreSQL 13 3.2.3
PostgreSQL 12 3.2.3
PostgreSQL 11 3.2.3

amcheck

amcheck provides functions for verifying relation integrity.

PostgreSQL version Extension version
PostgreSQL 16 1.3
PostgreSQL 15 1.3
PostgreSQL 14 1.3
PostgreSQL 13 1.2
PostgreSQL 12 1.2
PostgreSQL 11 1.1

anon (preview)

anon provides data anonymization tools.

PostgreSQL version Extension version
PostgreSQL 16 1.3.2 1
PostgreSQL 15 1.3.2 1
PostgreSQL 14 1.3.2 1
PostgreSQL 13 1.3.2 1
PostgreSQL 12 1.3.2 1
PostgreSQL 11 1.3.2 1

1 Enable corresponding libraries in the shared_preload_libraries server parameter.

bloom

bloom provides an index access method based on Bloom filters.

PostgreSQL version Extension version
PostgreSQL 16 1.0
PostgreSQL 15 1.0
PostgreSQL 14 1.0
PostgreSQL 13 1.0
PostgreSQL 12 1.0
PostgreSQL 11 1.0

btree_gin

btree_gin provides support for indexing common datatypes in GIN.

PostgreSQL version Extension version
PostgreSQL 16 1.3
PostgreSQL 15 1.3
PostgreSQL 14 1.3
PostgreSQL 13 1.3
PostgreSQL 12 1.3
PostgreSQL 11 1.3

btree_gist

btree_gist provides support for indexing common datatypes in GiST.

PostgreSQL version Extension version
PostgreSQL 16 1.7
PostgreSQL 15 1.7
PostgreSQL 14 1.6
PostgreSQL 13 1.5
PostgreSQL 12 1.5
PostgreSQL 11 1.5

citext

citext is a data type for case-insensitive character strings.

PostgreSQL version Extension version
PostgreSQL 16 1.6
PostgreSQL 15 1.6
PostgreSQL 14 1.6
PostgreSQL 13 1.6
PostgreSQL 12 1.6
PostgreSQL 11 1.5

cube

cube is a data type for multidimensional cubes.

PostgreSQL version Extension version
PostgreSQL 16 1.5
PostgreSQL 15 1.5
PostgreSQL 14 1.5
PostgreSQL 13 1.4
PostgreSQL 12 1.4
PostgreSQL 11 1.4

Use dblink to connect to other PostgreSQL databases from within a database.

PostgreSQL version Extension version
PostgreSQL 16 1.2
PostgreSQL 15 1.2
PostgreSQL 14 1.2
PostgreSQL 13 1.2
PostgreSQL 12 1.2
PostgreSQL 11 1.2

dict_int

dict_int provides a text search dictionary template for integers.

PostgreSQL version Extension version
PostgreSQL 16 1.0
PostgreSQL 15 1.0
PostgreSQL 14 1.0
PostgreSQL 13 1.0
PostgreSQL 12 1.0
PostgreSQL 11 1.0

dict_xsyn

dict_xsyn provides a text search dictionary template for extended synonym processing.

PostgreSQL version Extension version
PostgreSQL 16 1.0
PostgreSQL 15 1.0
PostgreSQL 14 1.0
PostgreSQL 13 1.0
PostgreSQL 12 1.0
PostgreSQL 11 1.0

earthdistance

earthdistance calculate great-circle distances on the surface of the Earth.

PostgreSQL version Extension version
PostgreSQL 16 1.1
PostgreSQL 15 1.1
PostgreSQL 14 1.1
PostgreSQL 13 1.1
PostgreSQL 12 1.1
PostgreSQL 11 1.1

fuzzystrmatch

fuzzystrmatch determine similarities and distance between strings.

PostgreSQL version Extension version
PostgreSQL 16 1.2
PostgreSQL 15 1.1
PostgreSQL 14 1.1
PostgreSQL 13 1.1
PostgreSQL 12 1.1
PostgreSQL 11 1.1

hstore

hstore is a data type for storing sets of (key, value) pairs.

PostgreSQL version Extension version
PostgreSQL 16 1.8
PostgreSQL 15 1.8
PostgreSQL 14 1.8
PostgreSQL 13 1.7
PostgreSQL 12 1.6
PostgreSQL 11 1.5

hypopg

hypopg provides hypothetical indexes for PostgreSQL.

PostgreSQL version Extension version
PostgreSQL 16 1.4.0
PostgreSQL 15 1.4.0
PostgreSQL 14 1.4.0
PostgreSQL 13 1.4.0
PostgreSQL 12 1.4.0
PostgreSQL 11 1.4.0

intagg

intagg is an obsolete extension that provides an integer aggregator and enumerator.

PostgreSQL version Extension version
PostgreSQL 16 1.1
PostgreSQL 15 1.1
PostgreSQL 14 1.1
PostgreSQL 13 1.1
PostgreSQL 12 1.1
PostgreSQL 11 1.1

intarray

intarray provides functions, operators, and index support for 1-D arrays of integers.

PostgreSQL version Extension version
PostgreSQL 16 1.5
PostgreSQL 15 1.5
PostgreSQL 14 1.5
PostgreSQL 13 1.3
PostgreSQL 12 1.2
PostgreSQL 11 1.2

isn

isn provides data types for international product numbering standards.

PostgreSQL version Extension version
PostgreSQL 16 1.2
PostgreSQL 15 1.2
PostgreSQL 14 1.2
PostgreSQL 13 1.2
PostgreSQL 12 1.2
PostgreSQL 11 1.2

lo

lo provides Large Object maintenance.

PostgreSQL version Extension version
PostgreSQL 16 1.1
PostgreSQL 15 1.1
PostgreSQL 14 1.1
PostgreSQL 13 1.1
PostgreSQL 12 1.1
PostgreSQL 11 1.1

login_hook

login_hook is a hook to execute login_hook.login() at login time.

PostgreSQL version Extension version
PostgreSQL 16 1.5
PostgreSQL 15 1.4
PostgreSQL 14 1.4
PostgreSQL 13 1.4
PostgreSQL 12 1.4
PostgreSQL 11 1.4

ltree

ltree is a data type for hierarchical tree-like structures.

PostgreSQL version Extension version
PostgreSQL 16 1.2
PostgreSQL 15 1.2
PostgreSQL 14 1.2
PostgreSQL 13 1.2
PostgreSQL 12 1.1
PostgreSQL 11 1.1

orafce

orafce provides functions and operators that emulate a subset of functions and packages from the Oracle RDBMS.

PostgreSQL version Extension version
PostgreSQL 16 4.4
PostgreSQL 15 3.24
PostgreSQL 14 3.18
PostgreSQL 13 3.18
PostgreSQL 12 3.18
PostgreSQL 11 3.7

pageinspect

pageinspect inspects the contents of database pages at a low level.

PostgreSQL version Extension version
PostgreSQL 16 1.12
PostgreSQL 15 1.11
PostgreSQL 14 1.9
PostgreSQL 13 1.8
PostgreSQL 12 1.7
PostgreSQL 11 1.7

pgaudit

pgaudit provides auditing functionality.

PostgreSQL version Extension version
PostgreSQL 16 16.0 1
PostgreSQL 15 1.7 1
PostgreSQL 14 1.6.2 1
PostgreSQL 13 1.5 1
PostgreSQL 12 1.4.3 1
PostgreSQL 11 1.3.2 1

1 Enable corresponding libraries in the shared_preload_libraries server parameter.

pg_buffercache

pg_buffercache examines the shared buffer cache.

PostgreSQL version Extension version
PostgreSQL 16 1.4
PostgreSQL 15 1.3
PostgreSQL 14 1.3
PostgreSQL 13 1.3
PostgreSQL 12 1.3
PostgreSQL 11 1.3

pg_cron

pg_cron is a job scheduler for PostgreSQL.

PostgreSQL version Extension version
PostgreSQL 16 1.6 1
PostgreSQL 15 1.6 1
PostgreSQL 14 1.6 1
PostgreSQL 13 1.6 1
PostgreSQL 12 1.6 1
PostgreSQL 11 1.4-1 1

1 Enable corresponding libraries in the shared_preload_libraries server parameter.

pgcrypto

pgcrypto provides cryptographic functions.

PostgreSQL version Extension version
PostgreSQL 16 1.3
PostgreSQL 15 1.3
PostgreSQL 14 1.3
PostgreSQL 13 1.3
PostgreSQL 12 1.3
PostgreSQL 11 1.3

pg_freespacemap

pg_freespacemap examines the free space map (FSM).

PostgreSQL version Extension version
PostgreSQL 16 1.2
PostgreSQL 15 1.2
PostgreSQL 14 1.2
PostgreSQL 13 1.2
PostgreSQL 12 1.2
PostgreSQL 11 1.2

pg_hint_plan

pg_hint_plan makes it possible to tweak PostgreSQL execution plans using so-called hints in SQL comments.

PostgreSQL version Extension version
PostgreSQL 16 1.6.0 1
PostgreSQL 15 1.5 1
PostgreSQL 14 1.4 1
PostgreSQL 13 1.3.7 1
PostgreSQL 12 1.3.7 1
PostgreSQL 11 1.3.7 1

1 Enable corresponding libraries in the shared_preload_libraries server parameter.

pglogical

pglogical manages PostgreSQL Logical Replication.

PostgreSQL version Extension version
PostgreSQL 16 2.4.4 1
PostgreSQL 15 2.4.2 1
PostgreSQL 14 2.4.1 1
PostgreSQL 13 2.4.1 1
PostgreSQL 12 2.4.1 1
PostgreSQL 11 2.4.1 1

1 Enable corresponding libraries in the shared_preload_libraries server parameter.

pg_partman

pg_partman manages partitioned tables by time or ID.

PostgreSQL version Extension version
PostgreSQL 16 5.0.1 1
PostgreSQL 15 4.7.1 1
PostgreSQL 14 4.6.1 1
PostgreSQL 13 4.5.0 1
PostgreSQL 12 4.5.0 1
PostgreSQL 11 4.5.0 1

1 Enable corresponding libraries in the shared_preload_libraries server parameter.

pg_prewarm

Prewarm relation data with pg_prewarm.

PostgreSQL version Extension version
PostgreSQL 16 1.2 1
PostgreSQL 15 1.2 1
PostgreSQL 14 1.2 1
PostgreSQL 13 1.2 1
PostgreSQL 12 1.2 1
PostgreSQL 11 1.2 1

1 Enable corresponding libraries in the shared_preload_libraries server parameter.

pg_repack

pg_repack reorganizes tables in PostgreSQL databases with minimal locks.

PostgreSQL version Extension version
PostgreSQL 16 1.4.7
PostgreSQL 15 1.4.7
PostgreSQL 14 1.4.7
PostgreSQL 13 1.4.7
PostgreSQL 12 1.4.7
PostgreSQL 11 1.4.7

pgrowlocks

pgrowlocks shows row-level locking information.

PostgreSQL version Extension version
PostgreSQL 16 1.2
PostgreSQL 15 1.2
PostgreSQL 14 1.2
PostgreSQL 13 1.2
PostgreSQL 12 1.2
PostgreSQL 11 1.2

pg_squeeze

pg_squeeze removes unused space from a relation.

PostgreSQL version Extension version
PostgreSQL 16 1.6 1
PostgreSQL 15 1.6 1
PostgreSQL 14 1.5 1
PostgreSQL 13 1.5 1
PostgreSQL 12 1.5 1
PostgreSQL 11 1.5 1

1 Enable corresponding libraries in the shared_preload_libraries server parameter.

pg_stat_statements

Track execution statistics of all SQL statements executed, with pg_stat_statements.

PostgreSQL version Extension version
PostgreSQL 16 1.10 1
PostgreSQL 15 1.10 1
PostgreSQL 14 1.9 1
PostgreSQL 13 1.8 1
PostgreSQL 12 1.7 1
PostgreSQL 11 1.6 1

1 Enable corresponding libraries in the shared_preload_libraries server parameter.

pgstattuple

Show tuple-level statistics, with pgstattuple.

PostgreSQL version Extension version
PostgreSQL 16 1.5
PostgreSQL 15 1.5
PostgreSQL 14 1.5
PostgreSQL 13 1.5
PostgreSQL 12 1.5
PostgreSQL 11 1.5

pg_trgm

pg_trgm provides text similarity measurement and index searching based on trigrams.

PostgreSQL version Extension version
PostgreSQL 16 1.6
PostgreSQL 15 1.6
PostgreSQL 14 1.6
PostgreSQL 13 1.5
PostgreSQL 12 1.4
PostgreSQL 11 1.4

pg_visibility

pg_visibility examine the visibility map and page-level visibility info.

PostgreSQL version Extension version
PostgreSQL 16 1.2
PostgreSQL 15 1.2
PostgreSQL 14 1.2
PostgreSQL 13 1.2
PostgreSQL 12 1.2
PostgreSQL 11 1.2

pgvector

pgvector is a vector data type and ivfflat and hnsw access methods.

PostgreSQL version Extension version
PostgreSQL 16 0.7.0
PostgreSQL 15 0.7.0
PostgreSQL 14 0.7.0
PostgreSQL 13 0.7.0
PostgreSQL 12 0.7.0
PostgreSQL 11 0.5.1

plpgsql

PL/pgSQL is a SQL procedural language.

PostgreSQL version Extension version
PostgreSQL 16 1.0
PostgreSQL 15 1.0
PostgreSQL 14 1.0
PostgreSQL 13 1.0
PostgreSQL 12 1.0
PostgreSQL 11 1.0

plv8

PL/JavaScript (v8) is a trusted procedural language.

PostgreSQL version Extension version
PostgreSQL 16 3.1.7
PostgreSQL 15 3.1.7
PostgreSQL 14 3.0.0
PostgreSQL 13 3.0.0
PostgreSQL 12 3.0.0
PostgreSQL 11 3.0.0

postgis

PostGIS geometry and geography spatial types and functions.

PostgreSQL version Extension version
PostgreSQL 16 3.3.3
PostgreSQL 15 3.3.1
PostgreSQL 14 3.2.3
PostgreSQL 13 3.2.3
PostgreSQL 12 3.2.3
PostgreSQL 11 3.2.3

postgis_raster

PostGIS raster types and functions.

PostgreSQL version Extension version
PostgreSQL 16 3.3.3
PostgreSQL 15 3.3.1
PostgreSQL 14 3.2.3
PostgreSQL 13 3.2.3
PostgreSQL 12 3.2.3
PostgreSQL 11 3.2.3

postgis_sfcgal

PostGIS SFCGAL functions.

PostgreSQL version Extension version
PostgreSQL 16 3.3.3
PostgreSQL 15 3.3.1
PostgreSQL 14 3.2.3
PostgreSQL 13 3.2.3
PostgreSQL 12 3.2.3
PostgreSQL 11 3.2.3

postgis_tiger_geocoder

PostGIS tiger geocoder and reverse geocoder.

PostgreSQL version Extension version
PostgreSQL 16 3.3.3
PostgreSQL 15 3.3.1
PostgreSQL 14 3.2.3
PostgreSQL 13 3.2.3
PostgreSQL 12 3.2.3
PostgreSQL 11 3.2.3

postgis_topology

PostGIS topology spatial types and functions.

PostgreSQL version Extension version
PostgreSQL 16 3.3.3
PostgreSQL 15 3.3.1
PostgreSQL 14 3.2.3
PostgreSQL 13 3.2.3
PostgreSQL 12 3.2.3
PostgreSQL 11 3.2.3

postgres_fdw

postgres_fdw is a foreign-data wrapper for remote PostgreSQL servers.

PostgreSQL version Extension version
PostgreSQL 16 1.1
PostgreSQL 15 1.1
PostgreSQL 14 1.1
PostgreSQL 13 1.0
PostgreSQL 12 1.0
PostgreSQL 11 1.0

postgres_protobuf

postgres_protobuf provides protocol buffers for PostgreSQL.

PostgreSQL version Extension version
PostgreSQL 16 0.2
PostgreSQL 15 0.2
PostgreSQL 14 0.2
PostgreSQL 13 0.2
PostgreSQL 12 0.2
PostgreSQL 11 N/A

semver

semver provides a semantic version data type.

PostgreSQL version Extension version
PostgreSQL 16 0.32.1
PostgreSQL 15 0.32.0
PostgreSQL 14 0.32.0
PostgreSQL 13 0.32.0
PostgreSQL 12 0.32.0
PostgreSQL 11 0.32.0

session_variable

session_variable provides registration and manipulation of session variables and constants.

PostgreSQL version Extension version
PostgreSQL 16 3.3
PostgreSQL 15 3.3
PostgreSQL 14 3.3
PostgreSQL 13 3.3
PostgreSQL 12 3.3
PostgreSQL 11 3.3

sslinfo

sslinfo provides information about SSL certificates.

PostgreSQL version Extension version
PostgreSQL 16 1.2
PostgreSQL 15 1.2
PostgreSQL 14 1.2
PostgreSQL 13 1.2
PostgreSQL 12 1.2
PostgreSQL 11 1.2

tablefunc

tablefunc provides functions that manipulate whole tables, including crosstab.

PostgreSQL version Extension version
PostgreSQL 16 1.0
PostgreSQL 15 1.0
PostgreSQL 14 1.0
PostgreSQL 13 1.0
PostgreSQL 12 1.0
PostgreSQL 11 1.0

tds_fdw

tds_fdw is a foreign data wrapper for querying a TDS database (SAP ASE or SQL Server).

PostgreSQL version Extension version
PostgreSQL 16 2.0.3
PostgreSQL 15 2.0.3
PostgreSQL 14 2.0.3
PostgreSQL 13 2.0.3
PostgreSQL 12 2.0.3
PostgreSQL 11 2.0.3

timescaledb

timescaledb enables scalable inserts and complex queries for time-series data.

PostgreSQL version Extension version
PostgreSQL 16 2.13.0 1
PostgreSQL 15 2.10.0 1
PostgreSQL 14 2.10.0 1
PostgreSQL 13 2.10.0 1
PostgreSQL 12 2.10.0 1
PostgreSQL 11 1.7.4 1

1 Enable corresponding libraries in the shared_preload_libraries server parameter.

tsm_system_rows

tsm_system_rows is a TABLESAMPLE method which accepts number of rows as a limit.

PostgreSQL version Extension version
PostgreSQL 16 1.0
PostgreSQL 15 1.0
PostgreSQL 14 1.0
PostgreSQL 13 1.0
PostgreSQL 12 1.0
PostgreSQL 11 1.0

tsm_system_time

tsm_system_time is a TABLESAMPLE method which accepts time in milliseconds as a limit.

PostgreSQL version Extension version
PostgreSQL 16 1.0
PostgreSQL 15 1.0
PostgreSQL 14 1.0
PostgreSQL 13 1.0
PostgreSQL 12 1.0
PostgreSQL 11 1.0

unaccent

unaccent provides a text search dictionary that removes accents.

PostgreSQL version Extension version
PostgreSQL 16 1.1
PostgreSQL 15 1.1
PostgreSQL 14 1.1
PostgreSQL 13 1.1
PostgreSQL 12 1.1
PostgreSQL 11 1.1

uuid-ossp

uuid-ossp generates universally unique identifiers (UUIDs).

PostgreSQL version Extension version
PostgreSQL 16 1.1
PostgreSQL 15 1.1
PostgreSQL 14 1.1
PostgreSQL 13 1.1
PostgreSQL 12 1.1
PostgreSQL 11 1.1