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 ADP/PostgreSQL

amcheck

1.3

Functions to verify table and index consistency. See Use amcheck

autoinc

1.0

Functions for autoincrementing fields

bloom

1.0

An index access method based on Bloom filters. See Use bloom

bool_plperl

1.0

Allows you to transform a text value to boolean in PL/Perl code. See Boolean value transformation

bool_plperlu

1.0

Allows you to transform a text value to boolean in PL/PerlU code. See Boolean value transformation

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. See Use cube

dblink

1.2

Executes queries in a remote database. See Use dblink

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

hstore_plperl

1.0

Implements transforms for the hstore type for the trusted PL/Perl language

hstore_plperlu

1.0

Implements transforms for the hstore type for the untrusted PL/Perl language

hstore_plpython3

1.0

Implements conversion between hstore data types and Python dictionaries (the dict type) within PL/Python3U procedures

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

jsonb_plperl

1.0

Implements transforms for the JSONB type for the trusted PL/Perl language

jsonb_plperlu

1.0

Implements transforms for the JSONB type for the untrusted PL/Perl language

jsonb_plpython3u

1.0

Implements transformation between JSONB data and Python data structures (dictionaries, lists, scalars) when using the PL/Python3U language

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

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

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

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. See Use PostGIS

postgis_raster

3.4.1

PostGIS raster types and functions. See Raster type

postgis_sfcgal

3.4.1

PostGIS SFCGAL functions. See postgis_sfcgal module

postgis_tiger_geocoder

3.4.1

PostGIS tiger geocoder and reverse geocoder. See postgis_tiger_geocoder module

postgis_topology

3.4.1

PostGIS topology spatial types and functions. See PostGIS topology

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

auth_delay

auth_delay.so

Allows the server to pause briefly before reporting an authentication failure. It makes brute-force attacks on databases more difficult

auto_explain

auto_explain.so

Allows logging execution plans of slow statements without running the EXPLAIN command. This is useful for tracking unoptimized queries in large applications

cyrillic_and_mic

cyrillic_and_mic.so

Used for character encoding conversions between Cyrillic character sets (such as ISO-8859-5, KOI8-R, and Windows-1251) and Mule Internal Code (MIC)

dict_snowball

dict_snowball.so

A dictionary template used for stemming words in full-text search. See Snowball dictionary

euc2004_sjis2004

euc2004_sjis2004.so

Used for character encoding conversion between EUC_JIS_2004 and Shift-JIS-2004. This library provides support for working with Japanese characters

euc_cn_and_mic

euc_cn_and_mic.so

Used for character encoding conversion between EUC-CN (Extended Unix Code for Chinese) and MIC (Multilingual Interchange Code)

euc_jp_and_sjis

euc_jp_and_sjis.so

Used for character encoding conversion between EUC_JP (Extended Unix Code for Japanese) and SJIS (Shift JIS)

euc_kr_and_mic

euc_kr_and_mic.so

Used for character encoding conversion between EUC-KR (Extended Unix Code for Korean) and MIC

euc_tw_and_big5

euc_tw_and_big5.so

Used for character encoding conversion between EUC_TW (Extended Unix Code for Chinese) and Big5 (a traditional Chinese character encoding)

latin2_and_win1250

latin2_and_win1250.so

Used for character encoding conversion between ISO-8859-2 (Latin2) and Windows-1250 (WIN1250)

libecpg

Shared libraries for ecpg

libpgtypes

Used for mapping PostgreSQL database types to C equivalents

libpq

Contains a set of library functions that allow client programs to pass queries to the PostgreSQL backend server and to receive the results of these queries

libpqwalreceiver

libpqwalreceiver.so

Enables a standby server to stream write-ahead logs (WAL) from a primary server using the libpq library

llvmjit

llvmjit.so

Implements Just-in-Time (JIT) compilation based on the LLVM platform

passwordcheck

passwordcheck.so

Checks the passwords set with the CREATE ROLE or ALTER ROLE commands and rejects passwords that are too weak

pgoutput

pgoutput.so

Used for built-in logical replication

pgxml

pgxml.so

Provides ADP/PostgreSQL with extended XML parsing and manipulation capabilities

sepgsql

sepgsql.so

Provides integration with the SELinux security subsystem

test_decoding

test_decoding.so

Decodes WAL data into a text-based format to demonstrate logical decoding capabilities

utf8_and_big5

utf8_and_big5.so

Used for character encoding conversion between UTF-8 (Unicode) and Big5 (a traditional Chinese character encoding)

utf8_and_cyrillic

utf8_and_cyrillic.so

Used for character encoding conversion between UTF-8 (Unicode) and Cyrillic character sets (such as ISO-8859-5, KOI8-R, and Windows-1251)

utf8_and_euc2004

utf8_and_euc2004.so

Used for character encoding conversion between UTF-8 (Unicode) and EUC_JIS_2004 (Japanese character encoding based on Extended Unix Code)

utf8_and_euc_cn

utf8_and_euc_cn.so

Used for character encoding conversion between UTF-8 (Unicode) and EUC-CN (Extended Unix Code for Chinese)

utf8_and_euc_jp

utf8_and_euc_jp.so

Used for character encoding conversion between UTF-8 (Unicode) and EUC_JP (Extended Unix Code for Japanese)

utf8_and_euc_kr

utf8_and_euc_kr.so

Used for character encoding conversion between UTF-8 (Unicode) and EUC-KR (Extended Unix Code for Korean)

utf8_and_euc_tw

utf8_and_euc_tw.so

Used for character encoding conversion between UTF-8 (Unicode) and EUC_TW (Extended Unix Code for traditional Chinese)

utf8_and_gb18030

utf8_and_gb18030.so

Used for character encoding conversion between UTF-8 (Unicode) and GB18030 (Chinese national standard for character encoding)

utf8_and_gbk

utf8_and_gbk.so

Used for character encoding conversion between UTF-8 (Unicode) and GBK (Chinese simplified)

utf8_and_iso8859_1

utf8_and_iso8859_1.so

Used for character encoding conversion between UTF-8 (Unicode) and ISO-8859-1 (Latin1)

utf8_and_iso8859

utf8_and_iso8859.so

Used for character encoding conversion between UTF-8 (Unicode) and ISO 8859 (Latin)

utf8_and_johab

utf8_and_johab.so

Used for character encoding conversion between UTF-8 (Unicode) and JOHAB (Korean character encoding)

utf8_and_sjis2004

utf8_and_sjis2004.so

Used for character encoding conversion between UTF-8 (Unicode) and Shift-JIS-2004 (Japanese character encoding)

utf8_and_sjis

utf8_and_sjis.so

Used for character encoding conversion between UTF-8 (Unicode) and Shift JIS (Japanese character encoding)

utf8_and_uhc

utf8_and_uhc.so

Used for character encoding conversion between UTF-8 (Unicode) and UHC (Unified Hangul Code, Korean character encoding)

utf8_and_win

utf8_and_win.so

Used for character encoding conversion between UTF-8 (Unicode) and Windows code pages (for example: WIN1251, WIN1252)