Postgres Pro
Downloads
Home   >   mailing lists

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

From Rui DeSousa
Subject Re: How to find the view modified date and time and user name
Date
Msg-id 7E9625EA-4492-4D5F-9BDB-853EF7ABC269@icloud.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>)
Responses Re: How to find the view modified date and time and user name
List pgsql-admin
Tree view


On Jun 6, 2024, at 11:44 PM, M Sarwar <sarwarmd02@outlook.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


A simple solution I used was to do a schema only dump daily and check in any changes into a git repo via a cronjob  Then the repo will track schema changes.

pgsql-admin by date:

Previous
From: Ron Johnson
Date:
Subject: Re: How to find the view modified date and time and user name
Next
From: Muhammad Ikram
Date:
Subject: Re: How to find the view modified date and time and user name