returning json data row from json query

From: "john(dot)tiger" <john(dot)tigernassau(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: returning json data row from json query
Date: 2014-01-04 04:17:25
Message-ID: 52C78B55.2070609@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

select * from users where jsondata->>'username' = 'jdoe' works but
returns field names, etc besides the data row. how can we get json
data back ?

select row_to_json from users where jsondata->>'username'='jdoe' didn't
work.

any ideas ? thks.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jayadevan M 2014-01-04 05:29:16 Re: authentication failure
Previous Message john.tiger 2014-01-04 02:30:52 debian 9.3 install history file permission denied