Re: Date created for tables

>You all are *grossly* over-complicating this.
Agree +1

On Mon, Dec 23, 2019 at 9:14 PM Ron <ronljohnsonjr(at)gmail(dot)com> wrote:

> 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.
>

--
*Melvin Davidson*
*Maj. Database & Exploration Specialist*
*Universe Exploration Command – UXC*
Employment by invitation only!