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