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

address_standardizer

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

adminpack

2.1

Administrative functions for ADPG/PostgreSQL

amcheck

1.3

Functions to verify table and index consistency

autoinc

1.0

Functions for autoincrementing fields

bloom

1.0

An index access method based on Bloom filters

btree_gin

1.3

Provides support for indexing common data types in GIN

btree_gist

1.7

Provides support for indexing common data types in GiST

citext

1.6

The case-insensitive character string type — citext

cube

1.5

The cube data type for representing multidimensional cubes

dblink

1.2

Executes queries in a remote database

dict_int

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

dict_xsyn

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

earthdistance

1.1

Calculates great-circle distances on the surface of the Earth

file_fdw

1.0

A foreign-data wrapper for flat file access

fuzzystrmatch

1.2

Determines similarities and distance between strings

hstore

1.8

A data type to store key/value pairs in a single value

insert_username

1.0

Functions for tracking the users who have changed a table

intagg

1.1

An integer aggregator and enumerator (obsolete)

intarray

1.5

Functions and operators for manipulating NULL-free arrays of integers

isn

1.2

Data types for international product numbering standards

lo

1.1

Provides support for managing Large Objects (also called LOs or BLOBs)

ltree

1.2

A data type for hierarchical tree-like structures

moddatetime

1.0

Functions for tracking last modification time

old_snapshot

1.0

Allows you to check the server state that is used to implement old_snapshot_threshold

pageinspect

1.12

Allows you to inspect the contents of database pages at a low level

pg_buffercache

1.4

Provides information about the state of the shared buffer cache

pg_freespacemap

1.2

Provides tools for exploring the free space map (FSM)

pg_prewarm

1.2

Preloads relation data into buffer caches

pg_stat_statements

1.10

Provides a means for tracking planning and execution statistics of all SQL statements executed by a server

pg_surgery

1.0

An extension to perform surgery on a damaged relation

pg_trgm

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

pg_visibility

1.2

Provides a means for examining the visibility map (VM) and page-level visibility information of a table

pgcrypto

1.3

Cryptographic functions

pg_walinspect

1.1

Provides SQL functions that allow you to inspect the contents of write-ahead log of a running cluster at a low level

pgrowlocks

1.2

Provides a function to show row locking information for a specified table

pgstattuple

1.5

Provides functionality to show tuple-level statistics

plpgsql

1.0

The PL/pgSQL procedural language. See Use PL/pgSQL

plperl

1.0

The PL/Perl procedural language

plperlu

1.0

The PL/PerlU untrusted procedural language

plpython3u

1.0

The PL/Python3U untrusted procedural language. See Use PL/Python

pltcl

1.0

The PL/Tcl procedural language. See Use PL/Tcl

pltclu

1.0

The PL/TclU untrusted procedural language. See Use PL/Tcl

postgis

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

postgres_fdw

1.1

Foreign-data wrapper to access data stored in external PostgreSQL servers

refint

1.0

Functions for implementing referential integrity (obsolete)

seg

1.4

The seg data type for representing line segments or floating-point intervals

sslinfo

1.2

Provides information about SSL certificates

tablefunc

1.0

Functions that return tables including crosstab

tcn

1.0

Provides a trigger function that notifies listeners of changes to any table on which it is attached

timescaledb

2.14.2

Enables scalable inserts and complex queries for time-series data

tsm_system_rows

1.0

Provides the table sampling method SYSTEM_ROWS, which can be used in the TABLESAMPLE clause of a SELECT command

tsm_system_time

1.0

Provides the table sampling method SYSTEM_TIME, which can be used in the TABLESAMPLE clause of a SELECT command

unaccent

1.1

A text search dictionary that removes accents (diacritic signs) from lexemes

uuid-ossp

1.1

Provides functions to generate universally unique identifiers (UUIDs) using one of several standard algorithms

xml2

1.1

Provides XPath querying and XSLT functionality

Found a mistake? Seleсt text and press Ctrl+Enter to report it