Pretty print JSON in python« an older post

Select value of jsonb column in PostgreSQL as text

Snippet kitt decided around 17:10 on 28 March 2024 to publish 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