Hi! I am unable to find cache table's name. :-( Mitar On Mon, Dec 24, 2018 at 1:01 AM Mitar <mmitar@xxxxxxxxx> wrote: > > Hi! > > On Sun, Dec 23, 2018 at 11:59 PM George Neuner <gneuner2@xxxxxxxxxxx> wrote: > > IIRC the cache table's name is generated. I don't know the proper > > incantations to get it from the catalogs, but an easy way to find it > > is to put the materialized view into its own tablespace, then search > > pg_tables for objects in that space. > > Oh, what a trick. :-) > > > Mitar > > -- > http://mitar.tnode.com/ > https://twitter.com/mitar_m -- http://mitar.tnode.com/ https://twitter.com/mitar_m