Supported extensions

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_orphaned

1.0

Handling orphaned files

pg_prewarm

1.2

Preloads relation data into buffer caches

pg_repack

1.5.2

Allows you to reorganize tables

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_vector

0.8.0

Allows you to work with vector data

pg_visibility

1.2

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

pgaudit

16.1

Provides detailed session and/or object audit logging via the standard PostgreSQL logging facility

pgauditlogtofile

1.6

An addon to pgaudit that redirects audit log lines to an independent file instead of using PostgreSQL server logger

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.15.0

Enables scalable inserts and complex queries for time-series data. See Use timescaledb

timescaledb_toolkit

1.19.0

Provides additional hyperfunctions

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