Zet - How do you get an output from an sql in json?

How do you get an output from an sql in json?

You can use the row_to_json function wrapping your named query.

Eg.

SELECT row_to_json(t) 
FROM ( 
	SELECT * FROM your_table_name WHERE your_condition 
) t;

#postgres