Hi! I am unable to find cache table's name. :-(
Mitar On Mon, Dec 24, 2018 at 1:01 AM Mitar <mmi...@gmail.com> wrote: > > Hi! > > On Sun, Dec 23, 2018 at 11:59 PM George Neuner <gneun...@comcast.net> 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
