On Mon, Nov 02, 2020 at 03:23:06PM +0530, paras paliya wrote: > I need the last updated time or alter time of the table. Like changing the > column name or adding/deleting a column. Is there any table or view from > which I can get? PostgreSQL doesn't keep that information. You can: 1. set log_statement to ddl (or more) to log all schema changes 2. use event triggers to do whatever you want at the time of change. Best regards, depesz
