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