Query with postgresql with json data

Grafana PostgreSQL
1

How do I perform a query in postgresql to get data in JOSN?

I have tried this way below, but it presents the error: db query error: pq: operator does not exist: text ->> unknown

SELECT ((old_data->>‘plano_id’)::NUMERIC) as value
FROM admcore_additive

2

“I have analyzed your problem, and a hope this document will help you to solve your problem.”
(https://stackoverflow.com/questions/29887094/operator-does-not-exist-integer-when-using-postgres?newreg=281fb0759a084250a4708b01a0ac6cc4)

3

welcome @suporteti8

what does the json/jsonb data look like in postgres and what you want to extract from the json data? and which visualization do you want to use?