Training
Module
Enable semantic search in Azure Database for PostgreSQL - Training
Learn to enable semantic search in Azure Database for PostgreSQL.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
The following extensions and modules are available for the Azure Database for the PostgreSQL service.
address_standardizer is used to parse an address into constituent elements. Generally used to support geocoding address normalization step.
PostgreSQL version | Extension version |
---|---|
17 | 3.5.0 |
16 | 3.3.3 |
15 | 3.3.1 |
14 | 3.2.3 |
13 | 3.2.3 |
12 | 3.2.3 |
11 | 3.2.3 |
address_standardizer_data_us is the Address Standardizer US dataset example.
PostgreSQL version | Extension version |
---|---|
17 | 3.5.0 |
16 | 3.3.3 |
15 | 3.3.1 |
14 | 3.2.3 |
13 | 3.2.3 |
12 | 3.2.3 |
11 | 3.2.3 |
age (Preview) provides graph database capabilities.
PostgreSQL version | Extension version |
---|---|
17 | N/A |
16 | 1.5.0 * |
15 | 1.5.0 * |
14 | 1.5.0 * |
13 | 1.5.0 * |
12 | N/A |
11 | N/A |
* Enable corresponding libraries in the shared_preload_libraries
server parameter.
amcheck provides functions for verifying relation integrity.
PostgreSQL version | Extension version |
---|---|
17 | 1.4 |
16 | 1.3 |
15 | 1.3 |
14 | 1.3 |
13 | 1.2 |
12 | 1.2 |
11 | 1.1 |
anon (Preview) provides data anonymization tools.
PostgreSQL version | Extension version |
---|---|
17 | 1.3.2 * |
16 | 1.3.2 * |
15 | 1.3.2 * |
14 | 1.3.2 * |
13 | 1.3.2 * |
12 | 1.3.2 * |
11 | 1.3.2 * |
* Enable corresponding libraries in the shared_preload_libraries
server parameter.
auto_explain provides a means for logging execution plans of slow statements automatically, without having to run EXPLAIN by hand
PostgreSQL version | Extension version |
---|---|
17 | N/A * |
16 | N/A * |
15 | N/A * |
14 | N/A * |
13 | N/A * |
12 | N/A * |
11 | N/A * |
* Enable corresponding libraries in the shared_preload_libraries
server parameter.
azure_ai provides Azure AI and ML Services integration for PostgreSQL.
PostgreSQL version | Extension version |
---|---|
17 | N/A |
16 | 1.1.0 |
15 | 1.1.0 |
14 | 1.1.0 |
13 | 1.1.0 |
12 | 1.1.0 |
11 | N/A |
azure_storage provides Azure Storage integration for PostgreSQL.
PostgreSQL version | Extension version |
---|---|
17 | N/A |
16 | 1.5 * |
15 | 1.5 * |
14 | 1.5 * |
13 | 1.5 * |
12 | 1.5 * |
11 | N/A |
* Enable corresponding libraries in the shared_preload_libraries
server parameter.
bloom provides an index access method based on Bloom filters.
PostgreSQL version | Extension version |
---|---|
17 | 1.0 |
16 | 1.0 |
15 | 1.0 |
14 | 1.0 |
13 | 1.0 |
12 | 1.0 |
11 | 1.0 |
btree_gin provides support for indexing common datatypes in GIN.
PostgreSQL version | Extension version |
---|---|
17 | 1.3 |
16 | 1.3 |
15 | 1.3 |
14 | 1.3 |
13 | 1.3 |
12 | 1.3 |
11 | 1.3 |
btree_gist provides support for indexing common datatypes in GiST.
PostgreSQL version | Extension version |
---|---|
17 | 1.7 |
16 | 1.7 |
15 | 1.7 |
14 | 1.6 |
13 | 1.5 |
12 | 1.5 |
11 | 1.5 |
citext is a data type for case-insensitive character strings.
PostgreSQL version | Extension version |
---|---|
17 | 1.6 |
16 | 1.6 |
15 | 1.6 |
14 | 1.6 |
13 | 1.6 |
12 | 1.6 |
11 | 1.5 |
cube is a data type for multidimensional cubes.
PostgreSQL version | Extension version |
---|---|
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 version |
---|---|
17 | 1.2 |
16 | 1.2 |
15 | 1.2 |
14 | 1.2 |
13 | 1.2 |
12 | 1.2 |
11 | 1.2 |
Note
Read the special considerations for extension dblink in Flexible Server.
dict_int provides a text search dictionary template for integers.
PostgreSQL version | Extension version |
---|---|
17 | 1.0 |
16 | 1.0 |
15 | 1.0 |
14 | 1.0 |
13 | 1.0 |
12 | 1.0 |
11 | 1.0 |
dict_xsyn provides a text search dictionary template for extended synonym processing.
PostgreSQL version | Extension version |
---|---|
17 | 1.0 |
16 | 1.0 |
15 | 1.0 |
14 | 1.0 |
13 | 1.0 |
12 | 1.0 |
11 | 1.0 |
earthdistance calculates great-circle distances on the surface of the Earth.
PostgreSQL version | Extension version |
---|---|
17 | 1.1 |
16 | 1.1 |
15 | 1.1 |
14 | 1.1 |
13 | 1.1 |
12 | 1.1 |
11 | 1.1 |
fuzzystrmatch determines similarities and distance between strings.
PostgreSQL version | Extension version |
---|---|
17 | 1.2 |
16 | 1.2 |
15 | 1.1 |
14 | 1.1 |
13 | 1.1 |
12 | 1.1 |
11 | 1.1 |
hll introduces a new data type hll which is a HyperLogLog data structure.
PostgreSQL version | Extension version |
---|---|
17 | N/A |
16 | 2.18 |
15 | 2.18 |
14 | 2.18 |
13 | 2.18 |
12 | 2.18 |
11 | N/A |
hstore is a data type for storing sets of (key, value) pairs.
PostgreSQL version | Extension version |
---|---|
17 | 1.8 |
16 | 1.8 |
15 | 1.8 |
14 | 1.8 |
13 | 1.7 |
12 | 1.6 |
11 | 1.5 |
hypopg provides hypothetical indexes for PostgreSQL.
PostgreSQL version | Extension version |
---|---|
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 is an obsolete extension that provides an integer aggregator and enumerator.
PostgreSQL version | Extension version |
---|---|
17 | 1.1 |
16 | 1.1 |
15 | 1.1 |
14 | 1.1 |
13 | 1.1 |
12 | 1.1 |
11 | 1.1 |
intarray provides functions, operators, and index support for 1-D arrays of integers.
PostgreSQL version | Extension version |
---|---|
17 | 1.5 |
16 | 1.5 |
15 | 1.5 |
14 | 1.5 |
13 | 1.3 |
12 | 1.2 |
11 | 1.2 |
isn provides data types for international product numbering standards.
PostgreSQL version | Extension version |
---|---|
17 | 1.2 |
16 | 1.2 |
15 | 1.2 |
14 | 1.2 |
13 | 1.2 |
12 | 1.2 |
11 | 1.2 |
lo provides data types for international product numbering standards.
PostgreSQL version | Extension version |
---|---|
17 | 1.1 |
16 | 1.1 |
15 | 1.1 |
14 | 1.1 |
13 | 1.1 |
12 | 1.1 |
11 | 1.1 |
login_hook is a hook to execute login_hook.login()
at login time.
PostgreSQL version | Extension version |
---|---|
17 | 1.5 |
16 | 1.5 |
15 | 1.4 |
14 | 1.4 |
13 | 1.4 |
12 | 1.4 |
11 | 1.4 |
ltree is a data type for hierarchical tree-like structures.
PostgreSQL version | Extension version |
---|---|
17 | 1.3 |
16 | 1.2 |
15 | 1.2 |
14 | 1.2 |
13 | 1.2 |
12 | 1.1 |
11 | 1.1 |
oracle_fdw is a foreign data wrapper for Oracle databases.
PostgreSQL version | Extension version |
---|---|
17 | 1.2 |
16 | 1.2 |
15 | 1.2 |
14 | 1.2 |
13 | 1.2 |
12 | 1.2 |
11 | N/A |
orafce provides functions and operators that emulate a subset of functions and packages from the Oracle RDBMS.
PostgreSQL version | Extension version |
---|---|
17 | 4.9 |
16 | 4.4 |
15 | 3.24 |
14 | 3.18 |
13 | 3.18 |
12 | 3.18 |
11 | 3.7 |
pageinspect inspects the contents of database pages at a low level.
PostgreSQL version | Extension version |
---|---|
17 | 1.12 |
16 | 1.12 |
15 | 1.11 |
14 | 1.9 |
13 | 1.8 |
12 | 1.7 |
11 | 1.7 |
pgaudit provides auditing functionality.
PostgreSQL version | Extension version |
---|---|
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 examines the shared buffer cache.
PostgreSQL version | Extension version |
---|---|
17 | 1.5 |
16 | 1.4 |
15 | 1.3 |
14 | 1.3 |
13 | 1.3 |
12 | 1.3 |
11 | 1.3 |
Note
Read the special considerations for extension pg_buffercache in Flexible Server.
pg_cron is a job scheduler for PostgreSQL.
PostgreSQL version | Extension version |
---|---|
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.
Note
Read the special considerations for extension pg_cron in Flexible Server.
pgcrypto provides cryptographic functions.
PostgreSQL version | Extension version |
---|---|
17 | 1.3 |
16 | 1.3 |
15 | 1.3 |
14 | 1.3 |
13 | 1.3 |
12 | 1.3 |
11 | 1.3 |
pg_diskann (Preview) is a scalable approximate nearest neighbor search algorithm for efficient vector search at any scale.
PostgreSQL version | Extension version |
---|---|
17 | N/A |
16 | 0.4.0 |
15 | 0.4.0 |
14 | 0.4.0 |
13 | N/A |
12 | N/A |
11 | N/A |
pg_failover_slots is a logical replication slot manager for failover purposes.
PostgreSQL version | Extension version |
---|---|
17 | 1.0.1 * |
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.
Note
Read the special considerations for extension pg_failover_slots in Flexible Server.
pg_freespacemap examines the free space map (FSM).
PostgreSQL version | Extension version |
---|---|
17 | 1.2 |
16 | 1.2 |
15 | 1.2 |
14 | 1.2 |
13 | 1.2 |
12 | 1.2 |
11 | 1.2 |
pg_hint_plan makes it possible to tweak PostgreSQL execution plans using so-called hints in SQL comments.
PostgreSQL version | Extension version |
---|---|
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.
Note
Read the special considerations for extension pg_hint_plan in Flexible Server.
pglogical manages PostgreSQL Logical Replication.
PostgreSQL version | Extension version |
---|---|
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 manages partitioned tables by time or ID.
PostgreSQL version | Extension version |
---|---|
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 manages partitioned tables by time or ID.
PostgreSQL version | Extension version |
---|---|
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 prewarms the cache with relation data.
PostgreSQL version | Extension version |
---|---|
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.
Note
Read the special considerations for extension pg_prewarm in Flexible Server.
pg_repack reorganizes tables in PostgreSQL databases with minimal locks.
PostgreSQL version | Extension version |
---|---|
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 |
Note
Read the special considerations for extension pg_repack in Flexible Server.
pgrouting provides geospatial routing functionality.
PostgreSQL version | Extension version |
---|---|
17 | N/A |
16 | N/A |
15 | 3.5.0 |
14 | 3.3.0 |
13 | 3.3.0 |
12 | 3.3.0 |
11 | 3.3.0 |
pgrowlocks shows row-level locking information.
PostgreSQL version | Extension version |
---|---|
17 | 1.2 |
16 | 1.2 |
15 | 1.2 |
14 | 1.2 |
13 | 1.2 |
12 | 1.2 |
11 | 1.2 |
pg_squeeze removes unused space from a relation.
PostgreSQL version | Extension version |
---|---|
17 | 1.7 * |
16 | 1.6 * |
15 | 1.6 * |
14 | 1.5 * |
13 | 1.5 * |
12 | 1.5 * |
11 | 1.5 * |
* Enable corresponding libraries in the shared_preload_libraries
server parameter.
pg_stat_statements tracks execution statistics of all SQL statements executed.
PostgreSQL version | Extension version |
---|---|
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.
Note
Read the special considerations for extension pg_stat_statements in Flexible Server.
pgstattuple shows tuple-level statistics.
PostgreSQL version | Extension version |
---|---|
17 | 1.5 |
16 | 1.5 |
15 | 1.5 |
14 | 1.5 |
13 | 1.5 |
12 | 1.5 |
11 | 1.5 |
Note
Read the special considerations for extension pgstattuple in Flexible Server.
pg_trgm provides text similarity measurement and index searching based on trigrams.
PostgreSQL version | Extension version |
---|---|
17 | 1.6 |
16 | 1.6 |
15 | 1.6 |
14 | 1.6 |
13 | 1.5 |
12 | 1.4 |
11 | 1.4 |
pg_visibility examines the visibility map and page-level visibility info.
PostgreSQL version | Extension version |
---|---|
17 | 1.2 |
16 | 1.2 |
15 | 1.2 |
14 | 1.2 |
13 | 1.2 |
12 | 1.2 |
11 | 1.2 |
plpgsql pL/pgSQL is a SQL procedural language.
PostgreSQL version | Extension version |
---|---|
17 | 1.0 |
16 | 1.0 |
15 | 1.0 |
14 | 1.0 |
13 | 1.0 |
12 | 1.0 |
11 | 1.0 |
plv8 pL/JavaScript (v8) is a trusted procedural language.
PostgreSQL version | Extension version |
---|---|
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 geometry and geography spatial types and functions.
PostgreSQL version | Extension version |
---|---|
17 | 3.5.0 |
16 | 3.3.3 |
15 | 3.3.1 |
14 | 3.2.3 |
13 | 3.2.3 |
12 | 3.2.3 |
11 | 3.2.3 |
postgis_raster raster types and functions.
PostgreSQL version | Extension version |
---|---|
17 | 3.5.0 |
16 | 3.3.3 |
15 | 3.3.1 |
14 | 3.2.3 |
13 | 3.2.3 |
12 | 3.2.3 |
11 | 3.2.3 |
postgis_sfcgal sFCGAL functions.
PostgreSQL version | Extension version |
---|---|
17 | 3.5.0 |
16 | 3.3.3 |
15 | 3.3.1 |
14 | 3.2.3 |
13 | 3.2.3 |
12 | 3.2.3 |
11 | 3.2.3 |
postgis_tiger_geocoder tiger geocoder and reverse geocoder.
PostgreSQL version | Extension version |
---|---|
17 | 3.5.0 |
16 | 3.3.3 |
15 | 3.3.1 |
14 | 3.2.3 |
13 | 3.2.3 |
12 | 3.2.3 |
11 | 3.2.3 |
postgis_topology spatial types and functions.
PostgreSQL version | Extension version |
---|---|
17 | 3.5.0 |
16 | 3.3.3 |
15 | 3.3.1 |
14 | 3.2.3 |
13 | 3.2.3 |
12 | 3.2.3 |
11 | 3.2.3 |
postgres_fdw is a foreign-data wrapper for remote PostgreSQL servers.
PostgreSQL version | Extension version |
---|---|
17 | 1.1 |
16 | 1.1 |
15 | 1.1 |
14 | 1.1 |
13 | 1.0 |
12 | 1.0 |
11 | 1.0 |
Note
Read the special considerations for extension postgres_fdw in Flexible Server.
postgres_protobuf provides protocol buffers for PostgreSQL.
PostgreSQL version | Extension version |
---|---|
17 | 0.2 |
16 | 0.2 |
15 | 0.2 |
14 | 0.2 |
13 | 0.2 |
12 | 0.2 |
11 | N/A |
semver provides a semantic version data type.
PostgreSQL version | Extension version |
---|---|
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 provides registration and manipulation of session variables and constants.
PostgreSQL version | Extension version |
---|---|
17 | 3.3 |
16 | 3.3 |
15 | 3.3 |
14 | 3.3 |
13 | 3.3 |
12 | 3.3 |
11 | 3.3 |
sslinfo provides information about SSL certificates.
PostgreSQL version | Extension version |
---|---|
17 | 1.2 |
16 | 1.2 |
15 | 1.2 |
14 | 1.2 |
13 | 1.2 |
12 | 1.2 |
11 | 1.2 |
tablefunc provides functions that manipulate whole tables, including crosstab.
PostgreSQL version | Extension version |
---|---|
17 | 1.0 |
16 | 1.0 |
15 | 1.0 |
14 | 1.0 |
13 | 1.0 |
12 | 1.0 |
11 | 1.0 |
tdigest implements t-digest, a data structure for on-line accumulation of rank-based statistics such as quantiles and trimmed means.
PostgreSQL version | Extension version |
---|---|
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 | N/A |
tds_fdw is a foreign data wrapper for querying a TDS database (SAP ASE or SQL Server).
PostgreSQL version | Extension version |
---|---|
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 enables scalable inserts and complex queries for time-series data.
PostgreSQL version | Extension version |
---|---|
17 | 2.17.2 * |
16 | 2.13.0 * |
15 | 2.10.0 * |
14 | 2.10.0 * |
13 | 2.10.0 * |
12 | 2.10.0 * |
11 | 1.7.4 * |
* Enable corresponding libraries in the shared_preload_libraries
server parameter.
topn returns the top values in a database according to some criteria.
PostgreSQL version | Extension version |
---|---|
17 | 2.7.0 |
16 | 2.7.0 |
15 | 2.7.0 |
14 | 2.7.0 |
13 | 2.7.0 |
12 | N/A |
11 | N/A |
tsm_system_rows is a TABLESAMPLE
method which accepts number of rows as a limit.
PostgreSQL version | Extension version |
---|---|
17 | 1.0 |
16 | 1.0 |
15 | 1.0 |
14 | 1.0 |
13 | 1.0 |
12 | 1.0 |
11 | 1.0 |
tsm_system_time is a TABLESAMPLE
method which accepts time in milliseconds as a limit.
PostgreSQL version | Extension version |
---|---|
17 | 1.0 |
16 | 1.0 |
15 | 1.0 |
14 | 1.0 |
13 | 1.0 |
12 | 1.0 |
11 | 1.0 |
unaccent provides a text search dictionary that removes accents.
PostgreSQL version | Extension version |
---|---|
17 | 1.1 |
16 | 1.1 |
15 | 1.1 |
14 | 1.1 |
13 | 1.1 |
12 | 1.1 |
11 | 1.1 |
uuid-ossp generates universally unique identifiers (UUIDs).
PostgreSQL version | Extension version |
---|---|
17 | 1.1 |
16 | 1.1 |
15 | 1.1 |
14 | 1.1 |
13 | 1.1 |
12 | 1.1 |
11 | 1.1 |
vector is a vector data type and ivfflat
and hnsw
access methods.
PostgreSQL version | Extension version |
---|---|
17 | 0.7.0 |
16 | 0.7.0 |
15 | 0.7.0 |
14 | 0.7.0 |
13 | 0.7.0 |
12 | 0.7.0 |
11 | 0.5.1 |
wal2json is an output plugin for logical decoding. It means that the plugin have 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 version |
---|---|
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.
Training
Module
Enable semantic search in Azure Database for PostgreSQL - Training
Learn to enable semantic search in Azure Database for PostgreSQL.