Skip to main content

PostgreSQL Extension

FDW

namedesc
dblinkconnect to other PostgreSQL databases from within a database
file_fdwforeign-data wrapper for flat file access
hstoredata type for storing sets of (key, value) pairs
hstore_plluaHstore transform for Lua
hstore_plluauHstore transform for untrusted Lua
hstore_plpython3utransform between hstore and plpython3u
postgres_fdwforeign-data wrapper for remote PostgreSQL servers

DateType

namedesc
citextdata type for case-insensitive character strings
cubedata type for multidimensional cubes
isndata types for international product numbering standards
ltreedata type for hierarchical tree-like structures
ltree_plpython3utransform between ltree and plpython3u

Index

namedesc
bloombloom access method - signature file based index
btree_ginsupport for indexing common datatypes in GIN
btree_gistsupport for indexing common datatypes in GiST
hypopgHypothetical indexes for PostgreSQL

功能

namedesc
pg_cronJob scheduler for PostgreSQL

DB

namedesc
timescaledbEnables scalable inserts and complex queries for time-series data
pgqGeneric queue for PostgreSQL

PL

namedesc
pldbgapiserver-side support for debugging PL/pgSQL functions
plluaLua as a procedural language
plluauLua as an untrusted procedural language
plpgsqlPL/pgSQL procedural language
plpgsql_checkextended check for plpgsql functions
plprofilerserver-side support for profiling PL/pgSQL functions
plproxyDatabase partitioning implemented as procedural language
plpython3uPL/Python3U untrusted procedural language
pltclPL/Tcl procedural language
pltcluPL/TclU untrusted procedural language

postgis

namedesc
postgisPostGIS geometry and geography spatial types and functions
postgis_rasterPostGIS raster types and functions
postgis_raster-3PostGIS raster types and functions
postgis_sfcgalPostGIS SFCGAL functions
postgis_sfcgal-3PostGIS SFCGAL functions
postgis_tiger_geocoderPostGIS tiger geocoder and reverse geocoder
postgis_tiger_geocoder-3PostGIS tiger geocoder and reverse geocoder
postgis_topologyPostGIS topology spatial types and functions
postgis_topology-3PostGIS topology spatial types and functions
postgis-3PostGIS geometry and geography spatial types and functions

MISC

namedesc
address_standardizerUsed to parse an address into constituent elements. Generally used to support geocoding address normalization step.
address_standardizer_data_usAddress Standardizer US dataset example
address_standardizer_data_us-3Address Standardizer US dataset example
address_standardizer-3Used to parse an address into constituent elements. Generally used to support geocoding address normalization step.
adminpackadministrative functions for PostgreSQL
amcheckfunctions for verifying relation integrity
autoincfunctions for autoincrementing fields
decoderbufsLogical decoding plugin that delivers WAL stream changes using a Protocol Buffer format
dict_inttext search dictionary template for integers
dict_xsyntext search dictionary template for extended synonym processing
earthdistancecalculate great-circle distances on the surface of the Earth
fuzzystrmatchdetermine similarities and distance between strings
insert_usernamefunctions for tracking who changed a table
intagginteger aggregator and enumerator (obsolete)
intarrayfunctions, operators, and index support for 1-D arrays of integers
jsonb_plpython3utransform between jsonb and plpython3u
loLarge Object maintenance
moddatetimefunctions for tracking last modification time
pageinspectinspect the contents of database pages at a low level
pg_auth_monmonitor connection attempts per user
pg_buffercacheexamine the shared buffer cache
pg_freespacemapexamine the free space map (FSM)
pg_monmonitor queries
pg_partmanExtension to manage partitioned tables by time or ID
pg_permissionsview object permissions and compare them with the desired state
pg_prewarmprewarm relation data
pg_repackReorganize tables in PostgreSQL databases with minimal locks
pg_stat_kcacheKernel statistics gathering
pg_stat_statementstrack planning and execution statistics of all SQL statements executed
pg_trgmtext similarity measurement and index searching based on trigrams
pg_visibilityexamine the visibility map (VM) and page-level visibility info
pgauditprovides auditing functionality
pgcryptocryptographic functions
pgl_ddl_deployautomated ddl deployment using pglogical
pglogicalPostgreSQL Logical Replication
pglogical_originDummy extension for compatibility when upgrading from Postgres 9.4
pglogical_tickerHave an accurate view on pglogical replication delay
pgrowlocksshow row-level locking information
pgstattupleshow tuple-level statistics
refintfunctions for implementing referential integrity (obsolete)
segdata type for representing line segments or floating-point intervals
set_usersimilar to SET ROLE but with added logging
sslinfoinformation about SSL certificates
tablefuncfunctions that manipulate whole tables, including crosstab
tcnTriggered change notifications
tsm_system_rowsTABLESAMPLE method which accepts number of rows as a limit
tsm_system_timeTABLESAMPLE method which accepts time in milliseconds as a limit
unaccenttext search dictionary that removes accents
uuid-osspgenerate universally unique identifiers (UUIDs)
xml2XPath querying and XSLT