On 12/23/19 7:01 PM, Bruce Momjian wrote:On Thu, Dec 5, 2019 at 05:10:20PM +0000, Chloe Dives wrote:Having moved to PostgreSQL from Oracle a few years ago I have been generally very impressed by Postgres, but there are a few things that I still miss. One of those is being able to see the created and last modified dates for database objects. Is this something that has been considered for implementation?I wrote a blog about this: https://momjian.us/main/blogs/pgblog/2017.html#November_21_2017 You all are grossly over-complicating this. By creation time, "we DBAs" think the time we ran "CREATE object", not when pg_dump, pg_basebackup and pg_update ran. Likewise, modification time is when we last ran an ALTER command ran, not when VACUUM ran (that's tracked elsewhere) or DML ran. That's all. --
Angular momentum makes the world go 'round. |
