Skip to content
Advertisement

How to get particular object from jsonb in PostgreSQL?

I have a table called ‘Test’ that holds two fields ‘qnId’ and ‘Answers’. ‘qnId’ stores a uuid and ‘Answers’ is a jsonb array that roughly looks like this:

how can I retrieve the value of "ans" of "user" with value 3. How can I retrieve the value using normal SQL queries

Advertisement

Answer

demo:db<>fiddle

You can use jsonb_array_elements() to expand the array elements into one row each. Afterwards you are able to filter the right elements using the ->> operator (documentation):

User contributions licensed under: CC BY-SA
4 People found this is helpful
Advertisement