| title | description | services | author | ms.author | manager | editor | ms.service | ms.topic | ms.date |
|---|---|---|---|---|---|---|---|---|---|
Using PostgreSQL extensions in Azure Database for PostgreSQL | Microsoft Docs |
Describes the ability to extend the functionality of your database using extensions in Azure Database for PostgreSQL. |
postgresql |
SaloniSonpal |
salonis |
jhubbard |
jasonwhowell |
postgresql |
article |
09/26/2017 |
PostgreSQL provides the ability to extend the functionality of your database using extensions. Extensions allow for bundling multiple related SQL objects together in a single package that can be loaded or removed from your database with a single command. After being loaded in the database, extensions can function as do built-in features. For more information on PostgreSQL extensions, see Packaging Related Objects into an Extension.
PostgreSQL extensions must be installed in your database before you can use them. To install a particular extension, run the CREATE EXTENSION command from psql tool to load the packaged objects into your database.
Azure Database for PostgreSQL currently supports a subset of key extensions as listed below. Extensions beyond the ones listed are not supported; you cannot create your own extension with Azure Database for PostgreSQL service.
The following tables list the standard PostgreSQL extensions that are currently supported by Azure Database for PostgreSQL. This information is also available by querying pg\_available\_extensions.
[!div class="mx-tableFixed"] | Extension | Description | |---|---| | chkpass | Provides a data type for auto-encrypted passwords. | | citext | Provides a case-insensitive character string type. | | cube | Provides a data type for multidimensional cubes. | | hstore | Provides a data type for storing sets of key/value pairs. | | isn | Provides data types for international product numbering standards. | | ltree | Provides a data type for hierarchical tree-like structures. |
[!div class="mx-tableFixed"] | Extension | Description | |---|---| | earthdistance | Provides a means to calculate great-circle distances on the surface of the Earth. | | fuzzystrmatch | Provides several functions to determine similarities and distance between strings. | | intarray | Provides functions and operators for manipulating null-free arrays of integers. | | pgcrypto | Provides cryptographic functions. | | pg_partman | Manages partitioned tables by time or ID. | | pg_trgm | Provides functions and operators for determining the similarity of alphanumeric text based on trigram matching. | | tablefunc | Provides functions that manipulate whole tables, including crosstab. | | uuid-ossp | Generates universally unique identifiers (UUIDs). |
[!div class="mx-tableFixed"] | Extension | Description | |---|---| | dict_int | Provides a text search dictionary template for integers. | | unaccent | A text search dictionary that removes accents (diacritic signs) from lexemes. |
[!div class="mx-tableFixed"] | Extension | Description | |---|---| | btree_gin | Provides sample GIN operator classes that implement B-tree like behavior for certain data types. | | btree_gist | Provides GiST index operator classes that implement B-tree. |
[!div class="mx-tableFixed"] | Extension | Description | |---|---| | plpgsql | PL/pgSQL loadable procedural language. |
[!div class="mx-tableFixed"] | Extension | Description | |---|---| | pg_buffercache | Provides a means for examining what's happening in the shared buffer cache in real time. | | pg_prewarm | Provides a way to load relation data into the buffer cache. | | pg_stat_statements | Provides a means for tracking execution statistics of all SQL statements executed by a server. | | pgrowlocks | Provides a means for showing row-level locking information. | | pgstattuple | Provides a means for showing tuple-level statistics. | | postgres_fdw | Foreign-data wrapper used to access data stored in external PostgreSQL servers. |
[!div class="mx-tableFixed"] | Extension | Description | |---|---| | PostGIS, postgis_topology, postgis_tiger_geocoder, postgis_sfcgal | Spatial and geographic objects for PostgreSQL. | | address_standardizer, address_standardizer_data_us | Used to parse an address into constituent elements. Used to support geocoding address normalization step. | | grouting | Extends the PostGIS / PostgreSQL geospatial database to provide geospatial routing functionality. |
If you don't see an extension that you'd like to use, let us know. Vote for existing requests or create new feedback and requests in our Customer feedback forum.