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

On 22-02-2016 19:42, Melvin Davidson wrote:
>
> On Mon, Feb 22, 2016 at 5:18 PM, Zlatko Asenov
> <zlatko(dot)asenov(at)gmail(dot)com <mailto:zlatko(dot)asenov(at)gmail(dot)com>> wrote:
>
> You may find useful a SIEM to record activity like this.
> ------------------------------------------------------------------------
> From: David G. Johnston <mailto:david(dot)g(dot)johnston(at)gmail(dot)com>
> Sent: ‎2/‎23/‎2016 0:14
> To: Edson F. Lidorio <mailto:edson(at)openmailbox(dot)org>
> Cc: pgsql-general <mailto:pgsql-general(at)postgresql(dot)org>
> Subject: Re: [GENERAL] Get the date of creation of objects in the
> database
>
> On Mon, Feb 22, 2016 at 3:00 PM, Edson F. Lidorio
> <edson(at)openmailbox(dot)org <mailto:edson(at)openmailbox(dot)org>>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
> <https://postgresql.uservoice.com/forums/21853-general/suggestions/5587129-add-relcreated-timestamp-column-to-pg-class-cata>
> --
> *Melvin Davidson*
> I reserve the right to fantasize. Whether or not you
> wish to share my fantasy is entirely up to you.
+ 1

Listen11similar discussionat [1]

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