How can i use update with json populate record in postgresql?

Question

In Postgresql how can I use JSON_POPULATE_RECORD with an Update query?

Sanket Patel · Accepted Answer · 2017-10-11 18:37:24Z

7

We can use UPDATE query with JSON_POPULATE_RECORD Below is the example for sample table name as a test and having three columns a,b,c with data type character varying.

update test set("a","b","c")=((select a,b,c from json_populate_record(NULL::test,'{"a":"first column","b":"second column","c":"third column"}')))

You can also use UPSERT with this query.

insert into test select * from json_populate_record(NULL::test, '{"a":"first column","b":"column","c":"column"}') ON CONFLICT ON CONSTRAINT a_PKey DO UPDATE SET("a","b","c")=((select a,b,c from json_populate_record(NULL::test,'{"a":"first column","b":"second column","c":"third column"}'))) ;

The above query will insert and if primary key conflicts or constraint conflicts then Record will be Updated.

edited Oct 11, 2017 at 18:37

answered Oct 11, 2017 at 18:30

Sanket Patel

94110 silver badges21 bronze badges

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

Collectives™ on Stack Overflow

How can i use update with json populate record in postgresql?

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