3 ms·
It is pretty easy to get any result set straight from PostgreSQL as json object: "WITH _ AS (" real query goes here ") SELECT COALESCE(array_to_json(array_agg
by limaoscarjuliet 5y ago
It is pretty easy to get any result set straight from PostgreSQL as json object:
"WITH _ AS ("
real query goes here
") SELECT COALESCE(array_to_json(array_agg(_.*)), '[]') AS xyz FROM _";
From there it behaves as standard JSON, wich can be easily loaded into any language.