GIN indices in general support the @> operator but not the = operator, unrelated to JSON. You can create a regular btree index on a particular json path and ge

GIN indices in general support the @> operator but not the = operator, unrelated to JSON. You can create a regular btree index on a particular json path and get an index usable for = operations on that path.