Re: Get the date of creation of objects in the database

["Edson F. Lidorio" <edson@xxxxxxxxxxxxxxx>]

On 22-02-2016 19:42, Melvin Davidson wrote:

On Mon, Feb 22, 2016 at 5:18 PM, Zlatko Asenov <zlatko.asenov@xxxxxxxxx> wrote:

You may find useful a SIEM to record activity like this.

---

From: David G. Johnston
Sent: ‎2/‎23/‎2016 0:14
To: Edson F. Lidorio
Cc: pgsql-general
Subject: Re: Get the date of creation of objects in the database

On Mon, Feb 22, 2016 at 3:00 PM, Edson F. Lidorio <edson@xxxxxxxxxxxxxxx> wrote:

Hello,

How to get the date of creation of objects in batabase?
For example: The date of creation of tables and trigger.

​ The only source of data for that question is the local filesystem.  If that is acceptable you can find examples online provided to others who have asked this question.

If you want something internal to the database the answer is no.  Those same searches will turn up the various reasons why such a feature has not gotten any strong traction from the developers.

This was my search query:  "postgresql object creation time"

David J.

Long ago, I requested that capability be added to PostgreSQL, as both Oracle and MS SQL Server store the creation date in their catalogs.

Perhaps if you care to add your support to mine, you can help influence the developers and it will be added in a future version.

See the link below.

Add relcreated to pg_class catalog
--

Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.

+ 1

Listen 1 1 similar discussion at [1]

[1] http://pgsql-hackers.postgresql.narkive.com/TQSHWw1l/proposal-store-timestamptz-of-database-creation-on-pg-database