Postgres Extensions
This is a list of extensions that are available in Hydra:
pg_buffercache (1.3) - examine the shared buffer cache
hstore_plluau (1.0) - Hstore transform for untrusted Lua
first_last_agg (0.1.4) - first() and last() aggregate functions
pg_stat_statements (1.9) - track planning and execution statistics of all SQL statements executed
pgcrypto (1.3) - cryptographic functions
address_standardizer-3 (3.2.1) - Used to parse an address into constituent elements. Generally used to support geocoding address normalization step.
unaccent (1.1) - text search dictionary that removes accents
xml2 (1.1) - XPath querying and XSLT
pgrowlocks (1.2) - show row-level locking information
jsonb_plpython3u (1.0) - transform between jsonb and plpython3u
fuzzystrmatch (1.1) - determine similarities and distance between strings
pglogical_origin (1.0.0) - Dummy extension for compatibility when upgrading from Postgres 9.4
pldbgapi (1.1) - server-side support for debugging PL/pgSQL functions
plproxy (2.10.0) - Database partitioning implemented as procedural language
moddatetime (1.0) - functions for tracking last modification time
pg_repack (1.4.8) - Reorganize tables in PostgreSQL databases with minimal locks
plpython3u (1.0) - PL/Python3U untrusted procedural language
pg_auth_mon (1.1) - monitor connection attempts per user
postgis_tiger_geocoder-3 (3.2.1) - PostGIS tiger geocoder and reverse geocoder
pltclu (1.0) - PL/TclU untrusted procedural language
postgis_sfcgal-3 (3.2.1) - PostGIS SFCGAL functions
sslinfo (1.2) - information about SSL certificates
pg_profile (0.3.6) - PostgreSQL load profile repository and report builder
pgaudit (1.6.2) - provides auditing functionality
hypopg (1.3.1) - Hypothetical indexes for PostgreSQL
old_snapshot (1.0) - utilities in support of old_snapshot_threshold
pgstattuple (1.5) - show tuple-level statistics
extra_window_functions (1.0) -
decoderbufs (0.1.0) - Logical decoding plugin that delivers WAL stream changes using a Protocol Buffer format
plpgsql (1.0) - PL/pgSQL procedural language
address_standardizer_data_us (3.2.1) - Address Standardizer US dataset example
pg_stat_kcache (2.2.1) - Kernel statistics gathering
pg_prewarm (1.2) - prewarm relation data
refint (1.0) - functions for implementing referential integrity (obsolete)
hstore_pllua (1.0) - Hstore transform for Lua
btree_gin (1.3) - support for indexing common datatypes in GIN
plpgsql_check (2.2) - extended check for plpgsql functions
amcheck (1.3) - functions for verifying relation integrity
tsm_system_rows (1.0) - TABLESAMPLE method which accepts number of rows as a limit
ltree_plpython3u (1.0) - transform between ltree and plpython3u
earthdistance (1.1) - calculate great-circle distances on the surface of the Earth
insert_username (1.0) - functions for tracking who changed a table
dblink (1.2) - connect to other PostgreSQL databases from within a database
postgis (3.2.1) - PostGIS geometry and geography spatial types and functions
pg_dirtyread (2) - Read dead but unvacuumed rows from table
postgis_tiger_geocoder (3.2.1) - PostGIS tiger geocoder and reverse geocoder
pg_cron (1.4-1) - Job scheduler for PostgreSQL
hstore_plpython3u (1.0) - transform between hstore and plpython3u
dict_xsyn (1.0) - text search dictionary template for extended synonym processing
pglogical_ticker (1.4) - Have an accurate view on pglogical replication delay
hstore (1.8) - data type for storing sets of (key, value) pairs
address_standardizer (3.2.1) - Used to parse an address into constituent elements. Generally used to support geocoding address normalization step.
postgis_topology-3 (3.2.1) - PostGIS topology spatial types and functions
cube (1.5) - data type for multidimensional cubes
pllua (2.0) - Lua as a procedural language
postgis_topology (3.2.1) - PostGIS topology spatial types and functions
pg_surgery (1.0) - extension to perform surgery on a damaged relation
intagg (1.1) - integer aggregator and enumerator (obsolete)
file_fdw (1.0) - foreign-data wrapper for flat file access
pglogical (2.4.2) - PostgreSQL Logical Replication
ltree (1.2) - data type for hierarchical tree-like structures
set_user (3.0) - similar to SET ROLE but with added logging
pltcl (1.0) - PL/Tcl procedural language
pg_tm_aux (1.1) - transfer manager auxilary functions
hll (2.16) - type for storing hyperloglog data
pg_visibility (1.2) - examine the visibility map (VM) and page-level visibility info
tablefunc (1.0) - functions that manipulate whole tables, including crosstab
pg_permissions (1.2) - view object permissions and compare them with the desired state
pageinspect (1.9) - inspect the contents of database pages at a low level
plluau (2.0) - Lua as an untrusted procedural language
pg_mon (1.0) - monitor queries
intarray (1.5) - functions, operators, and index support for 1-D arrays of integers
adminpack (2.1) - administrative functions for PostgreSQL
pg_trgm (1.6) - text similarity measurement and index searching based on trigrams
pg_freespacemap (1.2) - examine the free space map (FSM)
seg (1.4) - data type for representing line segments or floating-point intervals
plprofiler (4.1) - server-side support for profiling PL/pgSQL functions
pgl_ddl_deploy (2.1) - automated ddl deployment using pglogical
tsm_system_time (1.0) - TABLESAMPLE method which accepts time in milliseconds as a limit
uuid-ossp (1.1) - generate universally unique identifiers (UUIDs)
lo (1.1) - Large Object maintenance
postgis_raster (3.2.1) - PostGIS raster types and functions
dict_int (1.0) - text search dictionary template for integers
postgis_sfcgal (3.2.1) - PostGIS SFCGAL functions
postgis-3 (3.2.1) - PostGIS geometry and geography spatial types and functions
postgres_fdw (1.1) - foreign-data wrapper for remote PostgreSQL servers
isn (1.2) - data types for international product numbering standards
autoinc (1.0) - functions for autoincrementing fields
address_standardizer_data_us-3 (3.2.1) - Address Standardizer US dataset example
pg_partman (4.7.1) - Extension to manage partitioned tables by time or ID
bloom (1.0) - bloom access method - signature file based index
pgq_node (3.5) - Cascaded queue infrastructure
citext (1.6) - data type for case-insensitive character strings
pgq (3.5) - Generic queue for PostgreSQL
postgis_raster-3 (3.2.1) - PostGIS raster types and functions
tcn (1.0) - Triggered change notifications
btree_gist (1.6) - support for indexing common datatypes in GiST
parquet_s3_fdw (0.3) - foreign-data wrapper for parquet on S3
multicorn (2.4) - Multicorn2 Python3.6+ bindings for Postgres 11++ Foreign Data Wrapper
mysql_fdw (1.1) - Foreign data wrapper for querying a MySQL server
Last updated