Query JSONB column in Postgres

by Paulo Gonzalez

2023-01-26 | postgres sql jsonb

This was a Today I Learned (TIL) for me. Here is the syntax to query a JSONB column in Postgres:


select id, worker, errors
from oban_jobs
where args ->> 'an_id' = 'c2d70b80-b4b2-4e96-b0ed-ca746a0fc631'
order by inserted_at desc

So cool!

Thanks for reading!