On Fri, Aug 1, 2014 at 4:47 AM, Larry White <ljw1001@xxxxxxxxx> wrote: > Is there a way to get Postgres to index the table as if the JSON were there, > but not actually put the data in the table? > I could either store the docs > elsewhere and keep a reference, or compress them and put them in the table > in compressed form as a blob. No. This is equivalent to the creation of an index on a foreign table. Regards, -- Michael