[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: [ADMIN] How to find table creation time
From:       Jerry Sievers <gsievers19 () comcast ! net>
Date:       2014-04-08 17:43:18
Message-ID: 86mwfvd8eh.fsf () jerry ! enova ! com
[Download RAW message or body]

Nik Tek <niktek2005@gmail.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.consulting@comcast.net
p: 312.241.7800


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
[prev in list] [next in list] [prev in thread] [next in thread]