Rails Postgres how to query a jsonb column for empty objects?

Question

How do I get all the empty records for a jsonb column with Active Record ?

Are you looking for all rows where the jsonb column is null? Or, are you looking for all rows where the jsonb column is an empty object '{}'? Some example code/sql would help here. — MrWillihog, Jun 8 at 14:24
I am looking for all the rows where the jsonb column is an empty object '{}' . I actually tried Active Record query interface Model.where.not(my_column: {}) — Shani, Jun 9 at 9:56

MrWillihog · Accepted Answer · 2016-06-09 11:04:23Z

up vote 1 down vote accepted

You can query for empty objects in a JSONB column using the following syntax:

Model.where("column = '{}'")

answered Jun 9 at 11:04

MrWillihog

874412

add a comment |

1 Answer 1