RETURNING to_jsonb(...)

On 5/5/20 1:11 PM, Miles Elam wrote:

How can the new record returned from RETURNING to converted to jsonb?

For example something like:

INSERT INTO my_table (a, b, c) VALUES ('a', 'b', 'c')
RETURNING to_jsonb(*);

or

UPDATE my_table SET a = 'a'
RETURNING to_jsonb(*);

or

INSERT INTO my_table (a, b, c) VALUES ('a', 'b', 'c')

ON CONFLICT DO UPDATE SET a = EXCLUDED.a

RETURNING to_jsonb(*);

insert into sample_tbl values(3, 2) returning to_jsonb(sample_tbl.*);
to_jsonb
-----------------------------------
{"sample_id": 3, "freezer_fk": 2}
(1 row)

Thanks in advance

--
Adrian Klaver
adrian.klaver@aklaver.com