you should be able to index on an expression without adding the column. eg create index on blah((jsoncolumn->>'new_thing')); although I haven't tried it my

you should be able to index on an expression without adding the column. eg create index on blah((jsoncolumn->>'new_thing')); although I haven't tried it myself yet, I've been meaning to play with that feature.