Search PostgreSQL documentation

helloworldtableExtensionsExtensionspgrx example returning a one-row table containing a Hello World greeting. helloworldtable Functions and aggregatesFunctions and aggregates · Extensions hessra_authzExtensionsExtensionsBiscuit-token authorization helpers plus key and service-chain management inside PostgreSQL. authorization biscuit pgrx token hessra_authz SecuritySecurity · Extensions hexgridExtensionsExtensionsConfigurable hex grid on abstract surface hexgrid morton code hexgrid GeospatialGeospatial · Extensions historical_geocodingExtensionsExtensionsSQL toolkit for geocoding historical addresses by combining textual, temporal, and spatial evidence. address geocoding gis historical-data localisation historical_geocoding GeospatialGeospatial · Extensions hive_fdwExtensionsExtensionsForeign data wrapper for querying Apache Hive from PostgreSQL. fdw hive java jdbc hive_fdw Foreign data wrappersForeign data wrappers · Extensions hllExtensionsExtensionstype for storing hyperloglog data hll FeaturesFeatures · Extensions holycornExtensionsExtensionsRuby foreign data wrapper provider fdw foreign-data-wrapper mruby ruby holycorn Foreign data wrappersForeign data wrappers · Extensions hostnameExtensionsExtensionsGet the server host name gethostbyname host hostname pg_hostname UtilitiesUtilities · Extensions hsearchExtensionsExtensionsTantivy-backed BM25 index access method with WAL-logged storage. bm25 tantivy fts index hsearch Full-text searchFull-text search · Extensions hstoreExtensionsPG18F.17. hstore — hstore key/value datatype This module implements the hstore data type for storing sets of key/value pairs within a single PostgreSQL value. This can be useful in various scena…hstore — hstore key/value datatype hstore_hash_opsExtensionsExtensionsPostgreSQL hstore GIN operator classes: hash and exact pair indexes gin hstore indexing postgres postgres-extension postgresql hstore_hash_ops FeaturesFeatures · Extensions hstore_opsExtensionsExtensionsAlternative GIN operator classes for hstore, optimized for smaller indexes and faster containment queries. gin hstore index operator-class hstore_ops FeaturesFeatures · Extensions hstore_plluaExtensionsExtensionsHstore transform for Lua pllua Procedural languagesProcedural languages · Extensions hstore_plluauExtensionsExtensionsHstore transform for untrusted Lua pllua Procedural languagesProcedural languages · Extensions hstore_plperlExtensionsExtensionstransform between hstore and plperl plperl Procedural languagesProcedural languages · Extensions hstore_plperluExtensionsExtensionstransform between hstore and plperlu plperlu Procedural languagesProcedural languages · Extensions hstore_plphpExtensionsExtensionsTransform between hstore and PHP associative arrays for PL/php hstore php transform plphp Procedural languagesProcedural languages · Extensions hstore_plpython2uExtensionsExtensionstransform between hstore and plpython2u hstore_plpython2u Procedural languagesProcedural languages · Extensions hstore_plpython3uExtensionsExtensionstransform between hstore and plpython3u plpython3u Procedural languagesProcedural languages · Extensions hstore_plpythonuExtensionsExtensionstransform between hstore and plpythonu hstore_plpythonu Procedural languagesProcedural languages · Extensions hstore_plrubyExtensionsExtensionsTransform between hstore and Ruby Hashes for PL/Ruby hstore ruby transform plruby Procedural languagesProcedural languages · Extensions htcExtensionsExtensionsHorvitz-Thompson continuous-population estimator functions for PostgreSQL. estimator horvitz-thompson statistics htc Functions and aggregatesFunctions and aggregates · Extensions httpExtensionsExtensionsHTTP client for PostgreSQL, allows web page retrieval inside the database. supabase pg_http UtilitiesUtilities · Extensions hunspell_cs_czExtensionsExtensionsCzech Hunspell Dictionary hunspell Full-text searchFull-text search · Extensions hunspell_de_deExtensionsExtensionsGerman Hunspell Dictionary hunspell Full-text searchFull-text search · Extensions hunspell_en_usExtensionsExtensionsen_US Hunspell Dictionary hunspell Full-text searchFull-text search · Extensions hunspell_frExtensionsExtensionsFrench Hunspell Dictionary hunspell Full-text searchFull-text search · Extensions hunspell_ne_npExtensionsExtensionsNepali Hunspell Dictionary hunspell Full-text searchFull-text search · Extensions hunspell_nl_nlExtensionsExtensionsDutch Hunspell Dictionary hunspell Full-text searchFull-text search · Extensions hunspell_nn_noExtensionsExtensionsNorwegian (norsk) Hunspell Dictionary hunspell Full-text searchFull-text search · Extensions hunspell_pt_ptExtensionsExtensionsPortuguese Hunspell Dictionary hunspell Full-text searchFull-text search · Extensions hunspell_ru_ruExtensionsExtensionsRussian Hunspell Dictionary hunspell Full-text searchFull-text search · Extensions hunspell_ru_ru_aotExtensionsExtensionsRussian Hunspell Dictionary (from AOT.ru group) hunspell Full-text searchFull-text search · Extensions hunspell_xalExtensionsExtensionsKalmyk Hunspell dictionary for PostgreSQL full-text search full-text-search hunspell kalmyk kalmyk_hunspell Full-text searchFull-text search · Extensions hybrid_searchExtensionsExtensionsHybrid pgvector and full-text search helper functions for LangChain and Supabase. langchain tle vector langchain-hybrid_search AI and vectorsAI and vectors · Extensions hyperion_vaultExtensionsExtensionsEncrypted secrets vault for PostgreSQL with KMS envelope encryption and automatic rotation. pgrx hyperion_vault SecuritySecurity · Extensions hyperloglog_counterExtensionsExtensionsAggregation functions and data type for distinct estimation based on HyperLogLog. aggregate count distinct estimate hyperloglog distinct_estimators Functions and aggregatesFunctions and aggregates · Extensions hyperspaceExtensionsExtensionsFour-dimensional point, box, and circle types with B-tree and SP-GiST/KD-tree operator classes. btree data-type kd-tree spgist hyperspace GeospatialGeospatial · Extensions hypopgExtensionsExtensionsHypothetical indexes for PostgreSQL hypopg FeaturesFeatures · Extensions hypostatsExtensionsExtensionsDump and load pg_statistic rows as JSON for statistics experiments. pg-statistic pgrx statistics hypostats AdministrationAdministration · Extensions