How to insert JSON into Postgres via java?

Question

I have created a table books in PostgreSql.

CREATE TABLE books ( id integer, data json );

My Json:

 { "name": "Book the First", "author": { "first_name": "Bob", "last_name": "White" } }

How can i insert json into Postgres via java code?

Hope this will be useful http://stackoverflow.com/questions/35844138/how-can-i-insert-json-object-into-postgres-using-java-preparedstatement — dkb, Dec 08 '16 at 07:10

score 6 · Answer 1 · answered Dec 08 '16 at 09:23

Thank you :).This really helped me to resolve the issue.

String json = "{ \"name\": \"Book the First\", \"author\": { \"first_name\": \"Priya\", \"last_name\": \"White\" } }";
         PGobject jsonObject = new PGobject();
         jsonObject.setType("json");
         jsonObject.setValue(json);
         PreparedStatement stmt=c.prepareStatement("insert into books values(2,?)");
         stmt.setObject(1, jsonObject);

score 0 · Answer 2 · answered Dec 08 '16 at 09:53

0

I have another one doubt.How to split JSON key value pair and insert into postgreSql table's column.

For example my JSON looks like { "Name":"xyz" "salary":10000 }

I want to insert into separate columns Name and salary in Postgres.

answered Dec 08 '16 at 09:53

Priyadharsini

101
1
4

You must parse the json string – Maurice Perry Dec 08 '16 at 10:00
Still having doubts on this.how to split JSON using parser?can you pls explain it – Priyadharsini Dec 09 '16 at 06:22
The process will depend on the parser you choose – Maurice Perry Dec 09 '16 at 06:47

How to insert JSON into Postgres via java?

2 Answers2