Select value of jsonb column in PostgreSQL as text
Snippet
Instead of being asleep at 17:10 on 28 March 2024, kitt created this:
Select the fields in a JSONB field in postgres with ->>
. Use ->
for selecting in the form
SELECT id, serialized_params FROM good_jobs WHERE serialized_params->>arguments = '[111777111]' LIMIT 1;
Add new comment