How to view creation date and time of a relation

From: Shrikant Bhende <shrikantbhende(dot)net(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How to view creation date and time of a relation
Date: 2016-05-19 07:18:47
Message-ID: CADrerVVhsnFREsidmHofcWAFJ37FE3V0wfCDfRO9mTxaX=CLcQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

Our application executes come scripts with the code consist of DDL which
creates lot of objects in the database in various schemas,also there are
lot of connections firing the same code. I am able to locate the IP from
where the script is initiated (which is causing more load on the database
), but I would like to know if I can pinpoint the relations which are
created on a specific date and time or else I can do something through
which I get creation date and time of the objects.

--
Shrikant Bhende
+91-9975543712

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2016-05-19 07:28:26 Re: How to view creation date and time of a relation
Previous Message Tom Smith 2016-05-19 03:04:50 Re: first_value/last_value