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

Hi Sarwar

If you have WAL Files then you can decode them but that will be a tedious
task.

Regards
Kashif Zeeshan

On Fri, Jun 7, 2024 at 8:44 AM M Sarwar <sarwarmd02(at)outlook(dot)com> wrote:

> Hi Tom,
> I do not have DDL logs.
> Are you saying that I should have manually maintain it or are you
> referring to any existing logs on the database side?
> This is taken very seriously by our architect. This guy behaves like
> everything like auditor, Project Manager or whatever we can think of. 🙂
> Thanks,
> Sarwar
>
>
> ------------------------------
> *From:* Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> *Sent:* Thursday, June 6, 2024 9:14 PM
> *To:* Ron Johnson <ronljohnsonjr(at)gmail(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
>
> Ron Johnson <ronljohnsonjr(at)gmail(dot)com> writes:
> > What matters is that the DBA can see "ah, Bob altered table foo last
> > Thursday at 14:30. Let's check the log file to see what he did."
>
> I'm not finding that argument terribly convincing. If you have a
> DDL log file, you can grep it to find the last change (and the
> ones before that, in case it was Alice's fault not Bob's). If
> you don't have such a log file, how much does a last-changed
> timestamp really help you?
>
> regards, tom lane
>
>
>