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

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

is giving the following output
0
0

-------- Original message --------
From: M Sarwar <sarwarmd02(at)outlook(dot)com>
Date: 6/6/24 5:06 PM (GMT-05:00)
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: How to find the view modified date and time and user name

Hello,
Today in our environment, we noticed that view is altered by someone.
We want to know the date, time and modified user name.

Our environment :
1. aws / rds
2. Postgress 13.5
3. database with default configuration is running

We have not enabled any additional audit, security on top of default configuration.

I have check led aws / rds / Instance / database / logs and events / log / all today's logs

and could not find any evidence.

Any hint / help will be greatly appreciated.
Sarwar

Sent from my Galaxy