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