Re: Getting the queried result in the form of json structure - Mailing list pgsql-sql

From Hector Vass
Subject Re: Getting the queried result in the form of json structure
Date
Msg-id DB5PR0601MB2008C389C5CC5A21FABC1E7ABC630@DB5PR0601MB2008.eurprd06.prod.outlook.com
Whole thread Raw
In response to Getting the queried result in the form of json structure  (msn <pioneer.suri@gmail.com>)
List pgsql-sql
cast it

select info::text from sample;

________________________________________
From: pgsql-sql-owner@postgresql.org <pgsql-sql-owner@postgresql.org> on behalf of msn <pioneer.suri@gmail.com>
Sent: 26 April 2016 12:32
To: pgsql-sql@postgresql.org
Subject: [SQL] Getting the queried result in the form of json structure

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   ============   -
insertinto 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.


--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql


pgsql-sql by date:

Previous
From: msn
Date:
Subject: Getting the queried result in the form of json structure
Next
From: msn
Date:
Subject: Re: Getting the queried result in the form of json structure