Postgres functions

Get started with commonly-used Postgres functions with Neon's function guides. For other functions that Postgres supports, visit the official Postgres Functions and Operators documentation.

• array_to_json()

  Converts an SQL array to a JSON array

• dense_rank()

  Returns the rank of the current row without gaps

• json_array_elements()

  Expand a JSON array into a set of rows

• jsonb_array_elements()

  Expands a JSONB array into a set of rows

• json_build_object()

  Builds a JSON object out of a variadic argument list

• json_each()

  Expands JSON into a record per key-value pair

• jsonb_each()

  Expands JSONB into a record per key-value pair

• json_extract_path()

  Extracts a JSON sub-object at the specified path

• jsonb_extract_path()

  Extracts a JSONB sub-object at the specified path

• json_extract_path_text()

  Extracts a JSON sub-object at the specified path as text

• jsonb_extract_path_text()

  Extracts a JSONB sub-object at the specified path as text

• json_object()

  Creates a JSON object from key-value pairs

• jsonb_object()

  Creates a JSONB object from key-value pairs

• json_populate_record()

  Casts a JSON object to a record

• jsonb_populate_record()

  Casts a JSONB object to a record

• json_to_record()

  Converts a JSON object to a record

• jsonb_to_record()

  Convert a JSONB object to a record