Home > mailing lists

Re: How to find the view modified date and time and user name - Mailing list pgsql-admin

From	David G. Johnston
Subject	Re: How to find the view modified date and time and user name
Date	June 7 00:48:22
Msg-id	CAKFQuwZvmMCdcfgtSWYOVMaP-Y1YtYVbUsfosU-sKrw+TgnnYw@mail.gmail.com Whole thread Raw
In response to	RE: How to find the view modified date and time and user name (M Sarwar <sarwarmd02@outlook.com>)
List	pgsql-admin

On Thursday, June 6, 2024, M Sarwar <sarwarmd02@outlook.com> wrote:

Some additional information:-
select relfilenode from pg_class where relname = 'vw_tab_mcm_net_temp_yield';

is giving the following output
0
0

Views don’t have underlying files since they don’t have anything to store.

David J.

From: M Sarwar
Date: 07 June, 00:11:48
Subject: RE: How to find the view modified date and time and user name

From: "David G. Johnston"
Date: 07 June, 00:49:11
Subject: Re: How to find the view modified date and time and user name