Select value of jsonb column in PostgreSQL as text
Snippet
Yeah, kitt finished writing this at 17:10 on 28 March 2024
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