Re: How to find table creation time

From: Jerry Sievers <gsievers19(at)comcast(dot)net>
To: Nik Tek <niktek2005(at)gmail(dot)com>
Cc: "pgsql-admin\(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: How to find table creation time
Date: 2014-04-08 17:43:18
Message-ID: 86mwfvd8eh.fsf@jerry.enova.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Nik Tek <niktek2005(at)gmail(dot)com> writes:

> Hi,
>
> Is there a way to find table creation time in postgres?
> pg version is 9.0

Not retroactively unless (as already discussed here) you had DDL
logging enabled.

But see docs relating to EVENT triggers when you move to 9.3 or higher
release at some point.

>
> Thank you
> Nik
>

--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres(dot)consulting(at)comcast(dot)net
p: 312.241.7800

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Murthy Nunna 2014-04-08 18:27:41 Re: robust archiving of WAL segments
Previous Message Jason Mathis 2014-04-08 15:30:51 Re: How to find table creation time