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.