Le 14/10/2021 à 20:55, Gilles Darold a écrit :
gilles=# SELECT row_to_json(t.*) FROM htest0 t;
row_to_json
--------------------------
{"a":1,"b":"htest0 one"}
{"a":2,"b":"htest0 two"}
(2 rows)
gilles=# SELECT row_to_json(t) FROM htest0 t;
row_to_json
--------------------------
{"a":1,"b":"htest0 one"}
{"a":2,"b":"htest0 two"}
(2 rows)
Tom, I have probably not well understood what you said about do the
cases above. Do you mean that the column should not be visible too? I
have though not but maybe I'm wrong, I will fix that.
--
Gilles Darold
