How to filter a value in json field type on Postgres 9.2?
You would need the -&gt;&gt; operator instead:

select * from integrations.accounts where field -&gt;&gt; 'id' = 'xxxxxx';


But these operators were added with Postgres 9.3. Postgres 9.2 is just too old (and unsupported by now). It had barely more than the data type json itself. There seems to be a third-party extension "Json Enhancements for PostgreSQL 9.2":


https://clarkdave.net/2013/06/adding-json-enhancements-to-postgresql-9-2/
https://www.pgxn.org/dist/json_enhancements/doc/json_enhancements.html#Json.Enhancements.for.PostgreSQL.9.2


But I have never tried it and would much rather upgrade to a current, supported version of Postgres instead. See:


https://www.postgresql.org/support/versioning/