Editja

Ixxerja permezz ta’

List of extensions and modules by name

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

address_standardizer

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

PostgreSQL version Extension or module version
18 3.6.0
17 3.5.2
16 3.5.2
15 3.5.2
14 3.5.2
13 3.5.2
12 3.2.3
11 3.2.3

address_standardizer_data_us

address_standardizer_data_us is the Address Standardizer US dataset example.

PostgreSQL version Extension or module version
18 3.6.0
17 3.5.2
16 3.5.2
15 3.5.2
14 3.5.2
13 3.5.2
12 3.2.3
11 3.2.3

age

age (Preview) provides graph database capabilities.

PostgreSQL version Extension or module version
18 Not supported
17 Not supported
16 1.5.0 *
15 1.5.0 *
14 1.5.0 *
13 1.5.0 *
12 Not supported
11 Not supported

* Enable corresponding libraries in the shared_preload_libraries server parameter.

amcheck

amcheck provides functions for verifying relation integrity.

PostgreSQL version Extension or module version
18 1.5
17 1.4
16 1.3
15 1.3
14 1.3
13 1.2
12 1.2
11 1.1

anon

anon provides data anonymization tools.

PostgreSQL version Extension or module version
18 2.4.0 *
17 2.4.0 *
16 2.4.0 *
15 2.4.0 *
14 2.4.0 *
13 2.4.0 *
12 1.3.2 *
11 1.3.2 *

* Enable corresponding libraries in the shared_preload_libraries server parameter.

auto_explain

auto_explain provides a means for logging execution plans of slow statements automatically, without having to run EXPLAIN by hand.

PostgreSQL version Extension or module version
18 Without version *
17 Without version *
16 Without version *
15 Without version *
14 Without version *
13 Without version *
12 Without version *
11 Without version *

* Enable corresponding libraries in the shared_preload_libraries server parameter.

azure_ai

azure_ai provides Azure AI and ML Services integration for PostgreSQL.

PostgreSQL version Extension or module version
18 Not supported
17 1.3.1
16 1.3.1
15 1.3.1
14 1.3.1
13 1.3.1
12 1.3.1
11 Not supported

azure_storage

azure_storage provides Azure Storage integration for PostgreSQL.

PostgreSQL version Extension or module version
18 1.7 *
17 1.7 *
16 1.7 *
15 1.7 *
14 1.7 *
13 1.7 *
12 1.6 *
11 Not supported

* Enable corresponding libraries in the shared_preload_libraries server parameter.

bloom

bloom provides an index access method based on Bloom filters.

PostgreSQL version Extension or module version
18 1.0
17 1.0
16 1.0
15 1.0
14 1.0
13 1.0
12 1.0
11 1.0

btree_gin

btree_gin provides support for indexing common datatypes in GIN.

PostgreSQL version Extension or module version
18 1.3
17 1.3
16 1.3
15 1.3
14 1.3
13 1.3
12 1.3
11 1.3

btree_gist

btree_gist provides support for indexing common datatypes in GiST.

PostgreSQL version Extension or module version
18 1.8
17 1.7
16 1.7
15 1.7
14 1.6
13 1.5
12 1.5
11 1.5

citext

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

PostgreSQL version Extension or module version
18 1.8
17 1.6
16 1.6
15 1.6
14 1.6
13 1.6
12 1.6
11 1.5

credcheck

credcheck provides few general credential checks, which will be evaluated during the user creation, during the password change and user renaming.

PostgreSQL version Extension or module version
18 3.0.0 *
17 3.0.0 *
16 3.0.0 *
15 3.0.0 *
14 3.0.0 *
13 3.0.0 *
12 Not supported
11 Not supported

* Enable corresponding libraries in the shared_preload_libraries server parameter.

cube

cube is a data type for multidimensional cubes.

PostgreSQL version Extension or module version
18 1.5
17 1.5
16 1.5
15 1.5
14 1.5
13 1.4
12 1.4
11 1.4

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

PostgreSQL version Extension or module version
18 1.2
17 1.2
16 1.2
15 1.2
14 1.2
13 1.2
12 1.2
11 1.2

Read the special considerations for extension dblink in flexible server.

dict_int

dict_int provides a text search dictionary template for integers.

PostgreSQL version Extension or module version
18 1.0
17 1.0
16 1.0
15 1.0
14 1.0
13 1.0
12 1.0
11 1.0

dict_xsyn

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

PostgreSQL version Extension or module version
18 1.0
17 1.0
16 1.0
15 1.0
14 1.0
13 1.0
12 1.0
11 1.0

earthdistance

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

PostgreSQL version Extension or module version
18 1.2
17 1.2
16 1.2
15 1.1
14 1.1
13 1.1
12 1.1
11 1.1

fuzzystrmatch

fuzzystrmatch determines similarities and distance between strings.

PostgreSQL version Extension or module version
18 1.2
17 1.2
16 1.2
15 1.1
14 1.1
13 1.1
12 1.1
11 1.1

hll

hll introduces a new data type hll which is a HyperLogLog data structure.

PostgreSQL version Extension or module version
18 2.18
17 2.18
16 2.18
15 2.18
14 2.18
13 2.18
12 2.18
11 Not supported

hstore

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

PostgreSQL version Extension or module version
18 1.8
17 1.8
16 1.8
15 1.8
14 1.8
13 1.7
12 1.6
11 1.5

hypopg

hypopg provides hypothetical indexes for PostgreSQL.

PostgreSQL version Extension or module version
18 1.4.1
17 1.4.1
16 1.4.0
15 1.4.0
14 1.4.0
13 1.4.0
12 1.4.0
11 1.4.0

intagg

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

PostgreSQL version Extension or module version
18 1.1
17 1.1
16 1.1
15 1.1
14 1.1
13 1.1
12 1.1
11 1.1

intarray

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

PostgreSQL version Extension or module version
18 1.5
17 1.5
16 1.5
15 1.5
14 1.5
13 1.3
12 1.2
11 1.2

ip4r

ip4r provides a set of data types for IPv4 and IPv6 network addresses.

PostgreSQL version Extension or module version
18 2.4
17 2.4
16 2.4
15 2.4
14 2.4
13 2.4
12 Not supported
11 Not supported

isn

isn provides data types for international product numbering standards.

PostgreSQL version Extension or module version
18 1.3
17 1.2
16 1.2
15 1.2
14 1.2
13 1.2
12 1.2
11 1.2

lo

lo provides support for managing Large Objects (also called LOs or BLOBs). This includes a data type lo and a trigger lo_manage.

PostgreSQL version Extension or module version
18 1.2
17 1.1
16 1.1
15 1.1
14 1.1
13 1.1
12 1.1
11 1.1

login_hook

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

PostgreSQL version Extension or module version
18 1.5
17 1.5
16 1.5
15 1.4
14 1.4
13 1.4
12 1.4
11 1.4

ltree

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

PostgreSQL version Extension or module version
18 1.3
17 1.3
16 1.2
15 1.2
14 1.2
13 1.2
12 1.1
11 1.1

oracle_fdw

oracle_fdw is a foreign data wrapper for Oracle databases.

PostgreSQL version Extension or module version
18 1.2
17 1.2
16 1.2
15 1.2
14 1.2
13 1.2
12 1.2
11 Not supported

orafce

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

PostgreSQL version Extension or module version
18 4.9
17 4.9
16 4.4
15 3.24
14 3.18
13 3.18
12 3.18
11 3.7

pageinspect

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

PostgreSQL version Extension or module version
18 1.13
17 1.12
16 1.12
15 1.11
14 1.9
13 1.8
12 1.7
11 1.7

pgaudit

pgaudit provides auditing functionality.

PostgreSQL version Extension or module version
18 18.0 *
17 16.0 *
16 16.0 *
15 1.7 *
14 1.6.2 *
13 1.5 *
12 1.4.3 *
11 1.3.2 *

* Enable corresponding libraries in the shared_preload_libraries server parameter.

pg_buffercache

pg_buffercache examines the shared buffer cache.

PostgreSQL version Extension or module version
18 1.6
17 1.5
16 1.4
15 1.3
14 1.3
13 1.3
12 1.3
11 1.3

Read the special considerations for extension pg_buffercache in flexible server.

pg_cron

pg_cron is a job scheduler for PostgreSQL.

PostgreSQL version Extension or module version
18 1.6 *
17 1.6 *
16 1.6 *
15 1.6 *
14 1.6 *
13 1.6 *
12 1.6 *
11 1.4-1 *

* Enable corresponding libraries in the shared_preload_libraries server parameter. Read the special considerations for extension pg_cron in flexible server.

pgcrypto

pgcrypto provides cryptographic functions.

PostgreSQL version Extension or module version
18 1.4
17 1.3
16 1.3
15 1.3
14 1.3
13 1.3
12 1.3
11 1.3

pg_diskann

pg_diskann (Preview) is a scalable approximate nearest neighbor search algorithm for efficient vector search at any scale.

PostgreSQL version Extension or module version
18 Not supported
17 0.6.4
16 0.6.4
15 0.6.4
14 0.6.4
13 Not supported
12 Not supported
11 Not supported

pg_duckdb

pg_duckdb (Preview) integrates DuckDB columnar-vectorized analytics engine into PostgreSQL, enabling high-performance analytics and data-intensive applications.

PostgreSQL version Extension or module version
18 1.0.0 *
17 1.0.0 *
16 1.0.0 *
15 1.0.0 *
14 1.0.0 *
13 Not supported
12 Not supported
11 Not supported

* Enable corresponding libraries in the shared_preload_libraries server parameter.

pg_failover_slots

pg_failover_slots is a logical replication slot manager for failover purposes.

PostgreSQL version Extension or module version
18 Not supported *
17 Not supported *
16 1.0.1 *
15 1.0.1 *
14 1.0.1 *
13 1.0.1 *
12 1.0.1 *
11 1.0.1 *

* Enable corresponding libraries in the shared_preload_libraries server parameter. Read the special considerations for extension pg_failover_slots in flexible server.

pg_freespacemap

pg_freespacemap examines the free space map (FSM).

PostgreSQL version Extension or module version
18 1.3
17 1.2
16 1.2
15 1.2
14 1.2
13 1.2
12 1.2
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 or module version
18 1.8.0 *
17 1.7.0 *
16 1.6.0 *
15 1.5 *
14 1.4 *
13 1.3.7 *
12 1.3.7 *
11 1.3.7 *

* Enable corresponding libraries in the shared_preload_libraries server parameter. Read the special considerations for extension pg_hint_plan in flexible server.

pglogical

pglogical manages PostgreSQL Logical Replication.

PostgreSQL version Extension or module version
18 2.4.6 *
17 2.4.5 *
16 2.4.4 *
15 2.4.2 *
14 2.4.1 *
13 2.4.1 *
12 2.4.1 *
11 2.4.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 or module version
18 5.0.1 *
17 5.0.1 *
16 5.0.1 *
15 4.7.1 *
14 4.6.1 *
13 4.5.0 *
12 4.5.0 *
11 4.5.0 *

* Enable corresponding libraries in the shared_preload_libraries server parameter.

pg_partman_bgw

pg_partman_bgw manages partitioned tables by time or ID.

PostgreSQL version Extension or module version
18 5.0.1 *
17 5.0.1 *
16 5.0.1 *
15 4.7.1 *
14 4.6.1 *
13 4.5.0 *
12 4.5.0 *
11 4.5.0 *

* Enable corresponding libraries in the shared_preload_libraries server parameter.

pg_prewarm

pg_prewarm prewarms the cache with relation data.

PostgreSQL version Extension or module version
18 1.2 *
17 1.2 *
16 1.2 *
15 1.2 *
14 1.2 *
13 1.2 *
12 1.2 *
11 1.2 *

* Enable corresponding libraries in the shared_preload_libraries server parameter. Read the special considerations for extension pg_prewarm in flexible server.

pg_repack

pg_repack reorganizes tables in PostgreSQL databases with minimal locks.

PostgreSQL version Extension or module version
18 1.4.7
17 1.5.1
16 1.5.1
15 1.5.1
14 1.5.1
13 1.5.1
12 1.4.7
11 1.4.7

Read the special considerations for extension pg_repack in flexible server.

pgrouting

pgrouting provides geospatial routing functionality.

PostgreSQL version Extension or module version
18 3.8.0
17 3.8.0
16 3.8.0
15 3.5.0
14 3.3.0
13 3.3.0
12 3.3.0
11 3.3.0

pgrowlocks

pgrowlocks shows row-level locking information.

PostgreSQL version Extension or module version
18 1.2
17 1.2
16 1.2
15 1.2
14 1.2
13 1.2
12 1.2
11 1.2

pg_squeeze

pg_squeeze removes unused space from a relation.

PostgreSQL version Extension or module version
18 1.9 *
17 1.9 *
16 1.9 *
15 1.9 *
14 1.9 *
13 1.9 *
12 1.5 *
11 1.5 *

* Enable corresponding libraries in the shared_preload_libraries server parameter.

pg_stat_statements

pg_stat_statements tracks execution statistics of all SQL statements executed.

PostgreSQL version Extension or module version
18 1.12 *
17 1.11 *
16 1.10 *
15 1.10 *
14 1.9 *
13 1.8 *
12 1.7 *
11 1.6 *

* Enable corresponding libraries in the shared_preload_libraries server parameter. Read the special considerations for extension pg_stat_statements in flexible server.

pgstattuple

pgstattuple shows tuple-level statistics.

PostgreSQL version Extension or module version
18 1.5
17 1.5
16 1.5
15 1.5
14 1.5
13 1.5
12 1.5
11 1.5

Read the special considerations for extension pgstattuple in flexible server.

pg_trgm

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

PostgreSQL version Extension or module version
18 1.6
17 1.6
16 1.6
15 1.6
14 1.6
13 1.5
12 1.4
11 1.4

pg_visibility

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

PostgreSQL version Extension or module version
18 1.2
17 1.2
16 1.2
15 1.2
14 1.2
13 1.2
12 1.2
11 1.2

plpgsql

plpgsql pL/pgSQL is a SQL procedural language.

PostgreSQL version Extension or module version
18 1.0
17 1.0
16 1.0
15 1.0
14 1.0
13 1.0
12 1.0
11 1.0

plv8

plv8 pL/JavaScript (v8) is a trusted procedural language.

PostgreSQL version Extension or module version
18 3.1.10
17 3.1.7
16 3.1.7
15 3.1.7
14 3.0.0
13 3.0.0
12 3.0.0
11 3.0.0

postgis

postgis geometry and geography spatial types and functions.

PostgreSQL version Extension or module version
18 3.6.0
17 3.5.2
16 3.5.2
15 3.5.2
14 3.5.2
13 3.5.2
12 3.2.3
11 3.2.3

postgis_raster

postgis_raster raster types and functions.

PostgreSQL version Extension or module version
18 3.6.0
17 3.5.2
16 3.5.2
15 3.5.2
14 3.5.2
13 3.5.2
12 3.2.3
11 3.2.3

postgis_sfcgal

postgis_sfcgal sFCGAL functions.

PostgreSQL version Extension or module version
18 3.6.0
17 3.5.2
16 3.5.2
15 3.5.2
14 3.5.2
13 3.5.2
12 3.2.3
11 3.2.3

postgis_tiger_geocoder

postgis_tiger_geocoder tiger geocoder and reverse geocoder.

PostgreSQL version Extension or module version
18 3.6.0
17 3.5.2
16 3.5.2
15 3.5.2
14 3.5.2
13 3.5.2
12 3.2.3
11 3.2.3

postgis_topology

postgis_topology spatial types and functions.

PostgreSQL version Extension or module version
18 3.6.0
17 3.5.2
16 3.5.2
15 3.5.2
14 3.5.2
13 3.5.2
12 3.2.3
11 3.2.3

postgres_fdw

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

PostgreSQL version Extension or module version
18 1.2
17 1.1
16 1.1
15 1.1
14 1.1
13 1.0
12 1.0
11 1.0

Read the special considerations for extension postgres_fdw in flexible server.

postgres_protobuf

postgres_protobuf provides protocol buffers for PostgreSQL.

PostgreSQL version Extension or module version
18 0.2
17 0.2
16 0.2
15 0.2
14 0.2
13 0.2
12 0.2
11 Not supported

semver

semver provides a semantic version data type.

PostgreSQL version Extension or module version
18 0.32.1
17 0.32.1
16 0.32.1
15 0.32.0
14 0.32.0
13 0.32.0
12 0.32.0
11 0.32.0

session_variable

session_variable provides registration and manipulation of session variables and constants.

PostgreSQL version Extension or module version
18 3.4
17 3.4
16 3.4
15 3.4
14 3.4
13 3.4
12 3.3
11 3.3

sslinfo

sslinfo provides information about SSL certificates.

PostgreSQL version Extension or module version
18 1.2
17 1.2
16 1.2
15 1.2
14 1.2
13 1.2
12 1.2
11 1.2

tablefunc

tablefunc provides functions that manipulate whole tables, including crosstab.

PostgreSQL version Extension or module version
18 1.0
17 1.0
16 1.0
15 1.0
14 1.0
13 1.0
12 1.0
11 1.0

tdigest

tdigest implements t-digest, a data structure for on-line accumulation of rank-based statistics such as quantiles and trimmed means.

PostgreSQL version Extension or module version
18 1.4.2
17 1.4.2
16 1.4.2
15 1.4.2
14 1.4.2
13 1.4.2
12 1.4.2
11 Not supported

tds_fdw

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

PostgreSQL version Extension or module version
18 2.0.4
17 2.0.3
16 2.0.3
15 2.0.3
14 2.0.3
13 2.0.3
12 2.0.3
11 2.0.3

timescaledb

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

PostgreSQL version Extension or module version
18 Not supported
17 2.22.0 *
16 2.22.0 *
15 2.22.0 *
14 2.15.3 *
13 2.15.3 *
12 2.10.0 *
11 1.7.4 *

* Enable corresponding libraries in the shared_preload_libraries server parameter.

topn

topn returns the top values in a database according to some criteria.

PostgreSQL version Extension or module version
18 2.7.0
17 2.7.0
16 2.7.0
15 2.7.0
14 2.7.0
13 2.7.0
12 Not supported
11 Not supported

tsm_system_rows

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

PostgreSQL version Extension or module version
18 1.0
17 1.0
16 1.0
15 1.0
14 1.0
13 1.0
12 1.0
11 1.0

tsm_system_time

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

PostgreSQL version Extension or module version
18 1.0
17 1.0
16 1.0
15 1.0
14 1.0
13 1.0
12 1.0
11 1.0

unaccent

unaccent provides a text search dictionary that removes accents.

PostgreSQL version Extension or module version
18 1.1
17 1.1
16 1.1
15 1.1
14 1.1
13 1.1
12 1.1
11 1.1

uuid-ossp

uuid-ossp generates universally unique identifiers (UUIDs).

PostgreSQL version Extension or module version
18 1.1
17 1.1
16 1.1
15 1.1
14 1.1
13 1.1
12 1.1
11 1.1

vector

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

PostgreSQL version Extension or module version
18 0.8.1
17 0.8.0
16 0.8.0
15 0.8.0
14 0.8.0
13 0.8.0
12 0.7.0
11 0.5.1

wal2json

wal2json is an output plugin for logical decoding. It means that the plugin has access to tuples produced by INSERT and UPDATE. Also, UPDATE/DELETE old row versions can be accessed depending on the configured replica identity.

PostgreSQL version Extension or module version
18 2.6 *
17 2.6 *
16 2.4 *
15 2.4 *
14 2.2 *
13 2.2 *
12 2.2 *
11 2.2 *

* Enable corresponding libraries in the shared_preload_libraries server parameter.

Related content

  • Last updated on