Supported extensions
Extensions are special modules that provide additional database functionality by bundling several SQL objects into a package to use them as a single unit. Extensions loaded into a database can operate like features that are built-in. See Work with extensions.
The table below lists the extensions available for installation.
Extension name | Default version | Description |
---|---|---|
3.4.1 |
A rule-based address standardizer that is used to parse an address into constituent elements |
|
address_standardizer_data_us |
3.4.1 |
Contains data for standardizing US addresses |
2.1 |
Administrative functions for ADPG/PostgreSQL |
|
1.3 |
Functions to verify table and index consistency |
|
1.0 |
Functions for autoincrementing fields |
|
1.0 |
An index access method based on Bloom filters |
|
1.3 |
Provides support for indexing common data types in GIN |
|
1.7 |
Provides support for indexing common data types in GiST |
|
1.6 |
The case-insensitive character string type — |
|
1.5 |
The |
|
1.2 |
Executes queries in a remote database |
|
1.0 |
An example of an add-on dictionary template for full-text search. This example dictionary controls the indexing of integers, allowing such numbers to be indexed and preventing the number of unique words from growing too large |
|
1.0 |
An example of a text search dictionary template for extended synonym processing. This dictionary type replaces words with groups of their synonyms, and makes it possible to search for a word using any of its synonyms |
|
1.1 |
Calculates great-circle distances on the surface of the Earth |
|
1.0 |
A foreign-data wrapper for flat file access |
|
1.2 |
Determines similarities and distance between strings |
|
1.8 |
A data type to store key/value pairs in a single value |
|
1.0 |
Functions for tracking the users who have changed a table |
|
1.1 |
An integer aggregator and enumerator (obsolete) |
|
1.5 |
Functions and operators for manipulating |
|
1.2 |
Data types for international product numbering standards |
|
1.1 |
Provides support for managing Large Objects (also called LOs or BLOBs) |
|
1.2 |
A data type for hierarchical tree-like structures |
|
1.0 |
Functions for tracking last modification time |
|
1.0 |
Allows you to check the server state that is used to implement old_snapshot_threshold |
|
1.12 |
Allows you to inspect the contents of database pages at a low level |
|
1.4 |
Provides information about the state of the shared buffer cache |
|
1.2 |
Provides tools for exploring the free space map (FSM) |
|
1.2 |
Preloads relation data into buffer caches |
|
1.10 |
Provides a means for tracking planning and execution statistics of all SQL statements executed by a server |
|
1.0 |
An extension to perform surgery on a damaged relation |
|
1.6 |
Provides functions and operators for determining the similarity of alphanumeric text based on trigram matching and index operator classes that support fast searching for similar strings |
|
1.2 |
Provides a means for examining the visibility map (VM) and page-level visibility information of a table |
|
1.3 |
Cryptographic functions |
|
1.1 |
Provides SQL functions that allow you to inspect the contents of write-ahead log of a running cluster at a low level |
|
1.2 |
Provides a function to show row locking information for a specified table |
|
1.5 |
Provides functionality to show tuple-level statistics |
|
1.0 |
The PL/pgSQL procedural language. See Use PL/pgSQL |
|
1.0 |
The PL/Perl procedural language |
|
1.0 |
The PL/PerlU untrusted procedural language |
|
1.0 |
The PL/Python3U untrusted procedural language. See Use PL/Python |
|
1.0 |
The PL/Tcl procedural language. See Use PL/Tcl |
|
1.0 |
The PL/TclU untrusted procedural language. See Use PL/Tcl |
|
3.4.1 |
PostGIS geometry and geography spatial types and functions |
|
postgis_raster |
3.4.1 |
PostGIS raster types and functions |
postgis_sfcgal |
3.4.1 |
PostGIS SFCGAL functions |
postgis_tiger_geocoder |
3.4.1 |
PostGIS tiger geocoder and reverse geocoder |
postgis_topology |
3.4.1 |
PostGIS topology spatial types and functions |
1.1 |
Foreign-data wrapper to access data stored in external PostgreSQL servers |
|
1.0 |
Functions for implementing referential integrity (obsolete) |
|
1.4 |
The |
|
1.2 |
Provides information about SSL certificates |
|
1.0 |
Functions that return tables including |
|
1.0 |
Provides a trigger function that notifies listeners of changes to any table on which it is attached |
|
2.14.2 |
Enables scalable inserts and complex queries for time-series data |
|
1.0 |
Provides the table sampling method |
|
1.0 |
Provides the table sampling method |
|
1.1 |
A text search dictionary that removes accents (diacritic signs) from lexemes |
|
1.1 |
Provides functions to generate universally unique identifiers (UUIDs) using one of several standard algorithms |
|
1.1 |
Provides XPath querying and XSLT functionality |