Pretty print JSON in python« an older post

Select value of jsonb column in PostgreSQL as text

Snippet

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

Plain text

  • No HTML tags allowed.
  • Lines and paragraphs break automatically.