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.

JSON functions

• array_to_json()

  Convert an SQL array to a JSON array

• json_array_elements()

  Expand a JSON array into a set of rows

• jsonb_array_elements()

  Expand a JSONB array into a set of rows

• json_build_object()

  Build a JSON object out of a variadic argument list

• json_each()

  Expand JSON into a record per key-value pair

• jsonb_each()

  Expand JSONB into a record per key-value pair

• json_extract_path()

  Extract a JSON sub-object at the specified path

• jsonb_extract_path()

  Extract a JSONB sub-object at the specified path

• json_extract_path_text()

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

• jsonb_extract_path_text()

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

• json_object()

  Create a JSON object from key-value pairs

• jsonb_object()

  Create a JSONB object from key-value pairs

• json_populate_record()

  Cast a JSON object to a record

• jsonb_populate_record()

  Cast a JSONB object to a record

• json_to_record()

  Convert a JSON object to a record

• jsonb_to_record()

  Convert a JSONB object to a record

String functions

• concat()

  Concatenate strings

• substring()

  Extract a substring from a string

Window functions

• dense_rank()

  Return the rank of the current row without gaps

• lag()

  Access values from previous rows in a result set

• lead()

  Access values from subsequent rows in a result set