Insert JSON string into Postgres and return field

Question

I want to insert a JSON string into a Postgres table with a jsonb field and want the insert query to return a part of the JSON. For example, I want to return the id in the example below. What goes on the question marks?

insert into mytable (myjson)
values ('{"id":123}') returning ???

user330315 · Accepted Answer · 2016-10-03 15:40:19Z

25

Use the ->> operator to extract the value of the id attribute:

insert into mytable (myjson)
values ('{"id":123}') 
returning (myjson ->> 'id');

answered Oct 3, 2016 at 15:40

user330315

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Insert JSON string into Postgres and return field

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related