From: | msn <pioneer(dot)suri(at)gmail(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | Getting the queried result in the form of json structure |
Date: | 2016-04-26 11:32:00 |
Message-ID: | 1461670320290-5900554.post@n5.nabble.com |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
I am using postgresql for my webapplication. I am new to this
Postgresql-json. I Just want to get the select query result in the form of
json structure.
Here are my details:
Create table
============
- create table sample(id, serial, info jsonb);
Insert query
============
- insert into sample("info") values('{"person": {"phone":
9804484234,"name":{"firstname":"Alice", "lastname":"bob"}, "empId": "E067",
"age":25}');
select query:
=============
select "info"->'person'->>'lastname' from sample;
result: bob
but I want to get the above result along with the json nodes like below:
result: {"person":
{"name":
{"lastname":"bob"}
}
}
could any tell me how to get my expected result structure from database.
--
View this message in context: http://postgresql.nabble.com/Getting-the-queried-result-in-the-form-of-json-structure-tp5900554.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Hector Vass | 2016-04-26 14:08:40 | Re: Getting the queried result in the form of json structure |
Previous Message | msn | 2016-04-26 10:35:49 | Re: org.postgresql.util.PSQLException: ERROR: index row requires more memory than default(8191) |