Say I have a JSONB column, with a GIN index on it.
I can use
jsonb_object_keys() to fetch the keys for each row. But is there an efficient way of getting the unique set of keys, across all rows?
Surely the GIN index must have this information already, right?
NB: I know the "classic" solution: split the single column into a many-to-many relationship.