From: | Ron <ronljohnsonjr(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Date created for tables |
Date: | 2019-12-24 02:14:01 |
Message-ID: | 2e6cf0d7-bed4-6bbb-95c8-e090697cdb8a@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Melvin Davidson | 2019-12-24 02:23:04 | Re: Date created for tables |
Previous Message | Bruce Momjian | 2019-12-24 01:01:53 | Re: Date created for tables |