© 2026 Buobe

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

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

Published by

on •1 min read

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 JSON Jsonb Row Convert