Re: returning json data row from json query

john.tiger wrote
> 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.

Using what client?  There is no way, using SQL, to get a non-table output;
but your client might give you ways to ignore or suppress the column name.

And row_to_json is a function, you have to pass argument(s) to it to use it.
There is documentation explaining how to do so and what the end result will
look like.

David J.







--
View this message in context:
http://postgresql.1045698.n5.nabble.com/returning-json-data-row-from-json-query-tp5785293p5785303.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.