PostgreSQL – Column to Json/Jsonb

Table of Contents

PostgreSQL - Column to Json/Jsonb

I have a table coso_nhayen like this

image

row_to_json

select row_to_json(row) from (select * from coso_nhayen) row LIMIT 5;

image

to_jsonb

SELECT id, to_jsonb(t.*) - 'id' AS data
FROM   coso_nhayen t
LIMIT 5;

image

json_agg

SELECT json_agg(t) FROM coso_nhayen t;

image

array_agg

select array_agg(row) from (select * from coso_nhayen) row LIMIT 5;

image

array_to_string

select array_to_string(array_agg(row), '') from (select * from coso_nhayen) row LIMIT 5;

image

Leave a Reply

Your email address will not be published. Required fields are marked *