Using JSONB in PostgreSQL: How to Effectively Store & Index JSON Data in PostgreSQL
Scalegrid
JULY 17, 2020
CREATE INDEX datagin ON books USING gin (data); Existence Operators (?, ?|, ?& For example, find all books that are available in braille. demo=# select * from books where data ? demo=# select * from books where data ? demo=# explain analyze select * from books where data ? braille'; QUERY PLAN.
Let's personalize your content