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.
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.