Search PostgreSQL documentation

jieba_parserExtensionsExtensionsJieba parser for full-text search. chinese fts jieba parser jieba_parser Full-text searchFull-text search · Extensions jiebaparserExtensionsExtensionsPostgresql full-text search extension for chinese (jiaba engine) using shared mem. jiebaparser Full-text searchFull-text search · Extensions job_queueExtensionsExtensionsProof-of-concept database-side asynchronous job queue using dynamic PostgreSQL background workers. asynchronous background-worker job-queue pg_job_queue FeaturesFeatures · Extensions json_accessorsExtensionsExtensionsJSON accessor functions function json json_accessors Functions and aggregatesFunctions and aggregates · Extensions json_buildExtensionsExtensionsC functions and aggregate helpers for building complex PostgreSQL JSON objects and arrays. array build json object json_build Functions and aggregatesFunctions and aggregates · Extensions json_enhancements_no_hstoreExtensionsExtensionsBackport of pg 9.3 JSON enhancements to PostgreSQL 9.2 aggregate array enhancements hstore json json path keys path record values json_enhancements FeaturesFeatures · Extensions json_enhancements_with_hstoreExtensionsExtensionsBackport of pg 9.3 JSON enhancements to PostgreSQL 9.2 aggregate array enhancements hstore json json path keys path record values json_enhancements FeaturesFeatures · Extensions json_fdwExtensionsExtensionsForeign data wrapper for local and remote JSON document access. fdw foreign data wrapper json json_fdw json_fdw Foreign data wrappersForeign data wrappers · Extensions json_modelExtensionsExtensionsJSON Model PL/pgSQL Runtime - JSON value validation data type data validation json json model json_model FeaturesFeatures · Extensions json_queryExtensionsExtensionsGenerate PostgreSQL WHERE clause predicates from JSONB filter objects. json query-builder sql pg_json_query Functions and aggregatesFunctions and aggregates · Extensions json_schema_validateExtensionsExtensionsValidate JSON and JSONB data against JSON Schema in PostgreSQL json json-schema validation json_schema_validate FeaturesFeatures · Extensions json_utilsExtensionsExtensionsJSON type helper functions, operators, and a hash operator class for PostgreSQL 9.2+. json operator plpgsql pg_json_utils Functions and aggregatesFunctions and aggregates · Extensions json_validator_extExtensionsExtensionsValidate JSONB values against JSON Schema using Rust and pgrx json json-schema pgrx validation json_validator_ext FeaturesFeatures · Extensions jsonb_deep_sumExtensionsExtensionsRecursively sum numeric fields in JSONB objects aggregation jsonb jsonb_deep_sum Functions and aggregatesFunctions and aggregates · Extensions jsonb_deleteExtensionsExtensionshstore-style delete function and operator for jsonb jsonb operator jsonb_delete Functions and aggregatesFunctions and aggregates · Extensions jsonb_delete_arrayExtensionsExtensionsDelete jsonb keys or string elements listed in a text array array jsonb operator jsonb_delete_array Functions and aggregatesFunctions and aggregates · Extensions jsonb_explorerExtensionsExtensionsInspect jsonb trees and paths introspection jsonb jsonb_explorer Functions and aggregatesFunctions and aggregates · Extensions jsonb_extendExtensionsExtensionsMerge two or more jsonb values jsonb merge jsonb-extend Functions and aggregatesFunctions and aggregates · Extensions jsonb_extraExtensionsExtensionsExtra JSONB functions jsonb utility jsonb_extra Functions and aggregatesFunctions and aggregates · Extensions jsonb_opxExtensionsExtensionshstore-style functions and operators for jsonb jsonb operators jsonb_opx Functions and aggregatesFunctions and aggregates · Extensions jsonb_plperlExtensionsExtensionstransform between jsonb and plperl plperl Procedural languagesProcedural languages · Extensions jsonb_plperluExtensionsExtensionstransform between jsonb and plperlu plperlu Procedural languagesProcedural languages · Extensions jsonb_plphpExtensionsExtensionsTransform between jsonb and native PHP values for PL/php jsonb php transform plphp Procedural languagesProcedural languages · Extensions jsonb_plpython2uExtensionsExtensionsHistorical transform between jsonb and the untrusted PL/Python 2 language. jsonb_plpython2u Procedural languagesProcedural languages · Extensions jsonb_plpython3uExtensionsExtensionstransform between jsonb and plpython3u plpython3u Procedural languagesProcedural languages · Extensions jsonb_plpythonuExtensionsExtensionsTransform between JSONB and PL/PythonU values jsonb_plpythonu Procedural languagesProcedural languages · Extensions jsonb_plrubyExtensionsExtensionsTransform between jsonb and native Ruby data for PL/Ruby jsonb ruby transform plruby Procedural languagesProcedural languages · Extensions jsonb_schemaExtensionsExtensionsjsonb with separately stored schema jsonb schema storage jsonb_schema Data typesData types · Extensions jsonb_set_laxExtensionsExtensionsBackport of PostgreSQL 13 jsonb_set_lax for PostgreSQL 9.5 through 12 compatibility jsonb jsonb_set_lax Functions and aggregatesFunctions and aggregates · Extensions jsonbdExtensionsExtensionsCompression method for JSONB type compression jsonb jsonbd UtilitiesUtilities · Extensions jsonbxExtensionsExtensionsJsonb extension functions for PostgreSQL 9.4 backport function json operator jsonbx Functions and aggregatesFunctions and aggregates · Extensions jsoncdcExtensionsExtensionsJSON logical decoding output plugin cdc json logical-decoding rust jsoncdc Replication and streamsReplication and streams · Extensions jsonfunExtensionsExtensionsExtract JSON values by variadic dot-delimited key paths function json jsonfun Functions and aggregatesFunctions and aggregates · Extensions jsonknifeExtensionsExtensionsUseful jsonb inspection and transformation functions inspection jsonb transformation jsonknife Functions and aggregatesFunctions and aggregates · Extensions jsonpathExtensionsExtensionsRun JSONPath queries through a bundled JavaScript implementation in PLV8 json jsonpath plv8 jsonpath FeaturesFeatures · Extensions jsonschemaExtensionsExtensionsJSON Schema validation functions for PostgreSQL pgrx jsonschema FeaturesFeatures · Extensions jsqueryExtensionsExtensionsdata type for jsonb inspection jsquery FeaturesFeatures · Extensions jusquciExtensionsExtensionsFrench tokenizer and PostgreSQL full-text-search parser. french fts parser jusquci Full-text searchFull-text search · Extensions jx_ioExtensionsExtensionsExtension to export and import json and xml from/to postgres datatype json xml jx_io Replication and streamsReplication and streams · Extensions kadb_fdwExtensionsExtensionsTransactional Kafka foreign data wrapper for Arenadata DB and Greenplum fdw greenplum kafka kafka_adb_os Foreign data wrappersForeign data wrappers · Extensions