Re: How to find the view modified date and time and user name

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: M Sarwar <sarwarmd02(at)outlook(dot)com>
Cc: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: How to find the view modified date and time and user name
Date: 2024-06-06 21:48:22
Message-ID: CAKFQuwZvmMCdcfgtSWYOVMaP-Y1YtYVbUsfosU-sKrw+TgnnYw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thursday, June 6, 2024, M Sarwar <sarwarmd02(at)outlook(dot)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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2024-06-06 21:49:11 Re: How to find the view modified date and time and user name
Previous Message M Sarwar 2024-06-06 21:11:48 RE: How to find the view modified date and time and user name