json package:beam-postgres

DataType for JSON. See PgJSON for more information

DataType for JSONB. See PgJSON for more information

Postgres provides separate json_ and jsonb_ functions. However, we know what we're dealing with based on the type of data, so we can be less obtuse. For more information on how these functions behave, see the Postgres manual section on JSON.

The Postgres JSON type, which stores textual values that represent JSON objects. The type parameter indicates the Haskell type which the JSON encodes. This type must be a member of FromJSON and ToJSON in order for deserialization and serialization to work as expected. The defaultMigratableDbSettings function automatically assigns the postgres JSON type to fields with this type.

The Postgres JSONB type, which stores JSON-encoded data in a postgres-specific binary format. Like PgJSON, the type parameter indicates the Haskell type which the JSON encodes. Fields with this type are automatically given the Postgres JSONB type

Key-value pair, used as output of pgJsonEachText and pgJsonEach

Output row of pgJsonArrayElements and pgJsonArrayElementsText

Output row of pgJsonKeys

Postgres array_to_json function.

The json_agg or jsonb_agg aggregate.

The json_array_elements and jsonb_array_elements function. Use pgUnnest to join against the result

Like pgJsonArrayElements, but returning the values as Text

Postgres json_array_length function. The supplied json object should be an array, but this isn't checked at compile-time.

The json_each or jsonb_each function. Values returned as json or jsonb respectively. Use pgUnnest to join against the result

Like pgJsonEach, but returning text values instead

The json_object_keys and jsonb_object_keys function. Use pgUnnest to join against the result.