returning json data row from json query - Mailing list pgsql-general

From john.tiger
Subject returning json data row from json query
Date
Msg-id 52C78B55.2070609@gmail.com
Whole thread Raw
Responses Re: returning json data row from json query  (David Johnston <polobo@yahoo.com>)
List 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.


pgsql-general by date:

Previous
From: "john.tiger"
Date:
Subject: debian 9.3 install history file permission denied
Next
From: Jayadevan M
Date:
Subject: Re: authentication failure