Search PostgreSQL documentation

jsonb_path_query_firstFunctionsReferencejsonb_path_query_first Json Functions And Operators 12 Gets the first JSON item returned by JSON path for the specified JSON value. Returns NULL on no results. jsonb_path_query_first ( targe…Functions · Json Functions And Operators jsonb_path_query_first_tzFunctionsReferencejsonb_path_query_first_tz Json Functions And Operators 13 These functions act like their counterparts described above without the _tz suffix, except that these functions support comparisons …Functions · Json Functions And Operators jsonb_path_query_tzFunctionsReferencejsonb_path_query_tz Json Functions And Operators 13 These functions act like their counterparts described above without the _tz suffix, except that these functions support comparisons of dat…Functions · Json Functions And Operators 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_populate_recordFunctionsReferencejsonb_populate_record Json Functions And Operators 10 Expands the object in from_json to a row whose columns match the record type defined by base (see note below). jsonb_populate_record ( b…Functions · Json Functions And Operators jsonb_populate_record_validFunctionsReferencejsonb_populate_record_valid Json Functions And Operators 17 Function for testing jsonb_populate_record. Returns true if the input jsonb_populate_record would finish without an error for the …Functions · Json Functions And Operators jsonb_populate_recordsetFunctionsReferencejsonb_populate_recordset Json Functions And Operators 10 Expands the outermost array of objects in from_json to a set of rows whose columns match the record type defined by base (see note be…Functions · Json Functions And Operators jsonb_prettyFunctionsReferencejsonb_pretty Json Functions And Operators 10 Returns from_json as indented JSON text. jsonb_pretty ( from_json jsonb ) → text Returns from_json as indented JSON text. 11 12 13 Converts the g…Functions · Json Functions And Operators jsonb_schemaExtensionsExtensionsjsonb with separately stored schema jsonb schema storage jsonb_schema Data typesData types · Extensions jsonb_set_laxFunctionsReferencejsonb_set_lax Json Functions And Operators 13 If new_value is not NULL, behaves identically to jsonb_set. Otherwise behaves according to the value of null_value_treatment which must be one o…Functions · Json Functions And Operators 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 jsonb_strip_nullsFunctionsReferencejsonb_strip_nulls Json Functions And Operators 10 Returns from_json with all object fields that have null values omitted. Other null values are untouched. jsonb_strip_nulls ( from_json jsonb…Functions · Json Functions And Operators jsonb_to_recordFunctionsReferencejsonb_to_record Json Functions And Operators 10 Builds an arbitrary record from a JSON object (see note below). As with all functions returning record, the caller must explicitly define the …Functions · Json Functions And Operators jsonb_to_recordsetFunctionsReferencejsonb_to_recordset Json Functions And Operators 10 Builds an arbitrary set of records from a JSON array of objects (see note below). As with all functions returning record, the caller must e…Functions · Json Functions And Operators jsonb_to_tsvectorFunctionsReferencejsonb_to_tsvector Text Search Functions And Operators 13 Selects each item in the JSON document that is requested by the filter and converts each one to a tsvector, normalizing words accordi…Functions · Text Search Functions And Operators jsonb_typeofFunctionsReferencejsonb_typeof Json Functions And Operators 10 Returns the type of the outermost JSON value as a text string. Possible types are object, array, string, number, boolean, and null. jsonb_typeof …Functions · Json Functions And Operators 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 jsonpath TypeManual ChaptersPG188.14.7. jsonpath Type The jsonpath type implements support for the SQL/JSON path language in PostgreSQL to efficiently query JSON data. It provides a binary representation of the parsed SQL/…jsonpath Type jsonschemaExtensionsExtensionsJSON Schema validation functions for PostgreSQL pgrx jsonschema FeaturesFeatures · Extensions jsqueryExtensionsExtensionsdata type for jsonb inspection jsquery FeaturesFeatures · Extensions Julian DatesManual ChaptersPG18B.7. Julian Dates The Julian Date system is a method for numbering days. It is unrelated to the Julian calendar, though it is confusingly named similarly to that calendar. The Julian Date sy…Julian Dates jusquciExtensionsExtensionsFrench tokenizer and PostgreSQL full-text-search parser. french fts parser jusquci Full-text searchFull-text search · Extensions Just-in-Time Compilation (JIT)Manual ChaptersPG18Chapter 30. Just-in-Time Compilation (JIT) This chapter explains what just-in-time compilation is, and how it can be configured in PostgreSQL.Just-in-Time Compilation (JIT) justify_daysFunctionsReferencejustify_days Date/Time Functions And Operators 10 Adjust interval so 30-day time periods are represented as months justify_days ( interval ) → interval Adjust interval so 30-day time periods…Functions · Date/Time Functions And Operators justify_hoursFunctionsReferencejustify_hours Date/Time Functions And Operators 10 Adjust interval so 24-hour time periods are represented as days justify_hours ( interval ) → interval Adjust interval so 24-hour time perio…Functions · Date/Time Functions And Operators justify_intervalFunctionsReferencejustify_interval Date/Time Functions And Operators 10 Adjust interval using justify_days and justify_hours, with additional sign adjustments justify_interval ( interval ) → interval Adjust i…Functions · Date/Time Functions And Operators 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 kafgresExtensionsExtensionsKafka protocol broker embedded in PostgreSQL kafka broker pgrx kafgres CompatibilityCompatibility · Extensions