Postgres Pro
Downloads
Home   >   mailing lists

RETURNING to_jsonb(...) - Mailing list pgsql-general

From Miles Elam
Subject RETURNING to_jsonb(...)
Date
Msg-id CAALojA_MaDC5TnjiaF8hPZ6vmXjuRVEpRc7zPOXPx8jfyWp0Dw@mail.gmail.com
Whole thread Raw
Responses Re: RETURNING to_jsonb(...)  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: "Peter J. Holzer"
Date:
Subject: Re: Thoughts on how to avoid a massive integer update.
Next
From: Tom Lane
Date:
Subject: Re: PostgreSQL client hangs sometimes on 'EXEC SQL PREPARE sid_sisisinst FROM :select_anw;'