From: Edson F. Lidorio <edson@openmailbox.org>
To: Melvin Davidson <melvin6925@gmail.com>
To: Zlatko Asenov <zlatko.asenov@gmail.com>
Cc: David G. Johnston <david.g.johnston@gmail.com>
Cc: pgsql-general <pgsql-general@postgresql.org>
Subject: Re: Get the date of creation of objects in the database
Date: Mon, 22 Feb 2016 20:24:26 -0300
Message-ID: <56CB98AA.8040408@openmailbox.org> (raw)
In-Reply-To: <CANu8Fiw9FTY6LWpzzeMTR1w_X9qhGMU63fwxzXMh9ztY0zR0=Q@mail.gmail.com>
References: <56CB84F7.20803@openmailbox.org>
<CAKFQuwaW4vnYbR5aVhG_YFExqMAkZzKpRLnBaZ-BqONvZPFNEA@mail.gmail.com>
<56cb8920.c74fc20a.c69fa.5153@mx.google.com>
<CANu8Fiw9FTY6LWpzzeMTR1w_X9qhGMU63fwxzXMh9ztY0zR0=Q@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-general>
On 22-02-2016 19:42, Melvin Davidson wrote:
>
> On Mon, Feb 22, 2016 at 5:18 PM, Zlatko Asenov
> <zlatko.asenov@gmail.com <mailto:zlatko.asenov@gmail.com>> wrote:
>
> You may find useful a SIEM to record activity like this.
> ------------------------------------------------------------------------
> From: David G. Johnston <mailto:david.g.johnston@gmail.com>
> Sent: 2/23/2016 0:14
> To: Edson F. Lidorio <mailto:edson@openmailbox.org>
> Cc: pgsql-general <mailto:pgsql-general@postgresql.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@openmailbox.org <mailto:edson@openmailbox.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-c...;
> --
> *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...
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-general@postgresql.org
Cc: edson@openmailbox.org, melvin6925@gmail.com, zlatko.asenov@gmail.com, david.g.johnston@gmail.com
Subject: Re: Get the date of creation of objects in the database
In-Reply-To: <56CB98AA.8040408@openmailbox.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox