convert

Jan 9, 2023

How to convert an array to a JSON array in PostgreSQL

PostgreSQL® offers two types of data types to handle JSON data, JSON and JSONB, you can use the function array_to_json (array_to_jsonb for JSONB) to create a JSON array from an existing array.

Jan 9, 2023

How to convert a table row to JSON in PostgreSQL®?

PostgreSQL® offers two types of data types to handle JSON data, JSON and JSONB, you can use the function to_json (to_jsonb for JSONB) to convert a table row to a JSON object.

Francesco Tisiot

Mastodon Francesco comes from Verona, Italy and works as a Senior Developer Advocate at Aiven. With his many years of experience as a data analyst, he has stories to tell and advice for data-wranglers everywhere. Francesco loves sharing knowledge with others as a speaker and writer, and is on a mission to defend the world from bad Italian food!