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 |
dblink
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 |