Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] does postgres log the create/refresh of a materializedview anywhere? - Mailing list pgsql-general

From Kevin Grittner
Subject Re: [GENERAL] does postgres log the create/refresh of a materializedview anywhere?
Date
Msg-id CACjxUsN+0+VtPspVJovWK20PHN561R4bdENQ5awZSPV_gS3xWg@mail.gmail.com
Whole thread Raw
In response to [GENERAL] does postgres log the create/refresh of a materialized view anywhere?  (Jonathan Vanasco <postgres@2xlp.com>)
Responses Re: [GENERAL] does postgres log the create/refresh of a materializedview anywhere?
List pgsql-general
Tree view 
On Tue, Dec 13, 2016 at 5:57 PM, Jonathan Vanasco <postgres@2xlp.com> wrote:

> Is there a way to find out when a materialized view was
> created/refreshed?

> I can log this manually in postgresql if needed, but was hoping
> there was some "timestamp" on the view in a system table.

This is not currently tracked in the system catalogs.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] Install doesnt set SuperUser PW
Next
From: Melvin Davidson
Date:
Subject: Re: [GENERAL] does postgres log the create/refresh of a materializedview anywhere?