Postgres Pro
Downloads
Home   >   mailing lists

Re: Watching for view changes - Mailing list pgsql-general

From Mitar
Subject Re: Watching for view changes
Date
Msg-id CAKLmikOWV8_SDsD=8GQYdNYW1WuZn9MuZYRPhxmunNp3q4a5Cg@mail.gmail.com
Whole thread Raw
In response to Re: Watching for view changes  (George Neuner <gneuner2@comcast.net>)
Responses Re: Watching for view changes  (Mitar <mmitar@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Mitar
Date:
Subject: Re: Watching for view changes
Next
From: Mitar
Date:
Subject: Re: Watching for view changes