Postgres Pro
Downloads
Home   >   mailing lists

Thread: RETURNING to_jsonb(...)

RETURNING to_jsonb(...)

From
Miles Elam
Date:
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(*);


Thanks in advance

Re: RETURNING to_jsonb(...)

From
Adrian Klaver
Date:
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