Search PostgreSQL documentation

How to Use ItManual ChaptersPG18F.21.2. How to Use It Here's a simple example of usage: CREATE TABLE image (title text, raster lo); CREATE TRIGGER t_raster BEFORE UPDATE OR DELETE ON image FOR EACH ROW EXECUTE FUNCTION lo_…How to Use It How Update Rules WorkManual ChaptersPG1839.4.1. How Update Rules Work Keep the syntax: CREATE [ OR REPLACE ] RULE name AS ON event TO table [ WHERE condition ] DO [ ALSO | INSTEAD ] { NOTHING | command | ( command ; command ... ) …How Update Rules Work hsearchExtensionsExtensionsTantivy-backed BM25 index access method with WAL-logged storage. bm25 tantivy fts index hsearch Full-text searchFull-text search · Extensions hstoreFunctionsPG18hstore ( record ) → hstore Constructs an hstore from a record or row. hstore(ROW(1,2)) → "f1"=>"1", "f2"=>"2"hstore — hstore key/value datatype › hstore Operators and Functions 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 External RepresentationManual ChaptersPG18F.17.1. hstore External Representation The text representation of an hstore, used for input and output, includes zero or more key => value pairs separated by commas. Some examples: k => v fo…hstore External Representation hstore Operators and FunctionsManual ChaptersPG18F.17.2. hstore Operators and Functions The operators provided by the hstore module are shown in Table F.6, the functions in Table F.7. Table F.6. hstore Operators Operator Description Exampl…hstore Operators and Functions hstore — hstore key/value datatypeManual ChaptersPG18F.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 hstore_to_arrayFunctionsPG18hstore_to_array ( hstore ) → text[] Extracts an hstore's keys and values as an array of alternating keys and values. hstore_to_array('a=>1,b=>2') → {a,1,b,2}hstore — hstore key/value datatype › hstore Operators and Functions hstore_to_jsonFunctionsPG18hstore_to_json ( hstore ) → json Converts an hstore to a json value, converting all non-null values to JSON strings. This function is used implicitly when an hstore value is cast to json. hs…hstore — hstore key/value datatype › hstore Operators and Functions hstore_to_json_looseFunctionsPG18hstore_to_json_loose ( hstore ) → json Converts an hstore to a json value, but attempts to distinguish numerical and Boolean values so they are unquoted in the JSON. hstore_to_json_loose('"a…hstore — hstore key/value datatype › hstore Operators and Functions hstore_to_jsonbFunctionsPG18hstore_to_jsonb ( hstore ) → jsonb Converts an hstore to a jsonb value, converting all non-null values to JSON strings. This function is used implicitly when an hstore value is cast to jsonb…hstore — hstore key/value datatype › hstore Operators and Functions hstore_to_jsonb_looseFunctionsPG18hstore_to_jsonb_loose ( hstore ) → jsonb Converts an hstore to a jsonb value, but attempts to distinguish numerical and Boolean values so they are unquoted in the JSON. hstore_to_jsonb_loose…hstore — hstore key/value datatype › hstore Operators and Functions hstore_to_matrixFunctionsPG18hstore_to_matrix ( hstore ) → text[] Extracts an hstore's keys and values as a two-dimensional array. hstore_to_matrix('a=>1,b=>2') → {{a,1},{b,2}}hstore — hstore key/value datatype › hstore Operators and Functions htcExtensionsExtensionsHorvitz-Thompson continuous-population estimator functions for PostgreSQL. estimator horvitz-thompson statistics htc Functions and aggregatesFunctions and aggregates · Extensions HTMLManual ChaptersPG18J.3.1. HTML To build the HTML version of the documentation: doc/src/sgml$ make html This is also the default target. The output appears in the subdirectory html. To produce HTML documentatio…HTML httpExtensionsExtensionsHTTP client for PostgreSQL, allows web page retrieval inside the database. supabase pg_http UtilitiesUtilities · Extensions huge_page_sizeConfigurationReferencehuge_page_size Resource Usage 14 Controls the size of huge pages, when they are enabled with huge_pages. The default is zero (0). When set to 0, the default huge page size on the system will…Configuration · Resource Usage huge_pagesConfigurationReferencehuge_pages Resource Usage 10 Enables/disables the use of huge memory pages. Valid values are try (the default), on, and off. At present, this feature is supported only on Linux. The setting …Configuration · Resource Usage huge_pages_statusConfigurationReferencehuge_pages_status Preset Options 17 Reports the state of huge pages in the current instance: on, off, or unknown (if displayed with postgres -C). This parameter is useful to determine whethe…Configuration · Preset Options 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