Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aXzsn-0007PY-IM for pgsql-general@arkaria.postgresql.org; Mon, 22 Feb 2016 23:27:13 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aXzsn-0003pU-48 for pgsql-general@arkaria.postgresql.org; Mon, 22 Feb 2016 23:27:13 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aXzqU-0008Ai-04 for pgsql-general@postgresql.org; Mon, 22 Feb 2016 23:24:50 +0000 Received: from smtp1.openmailbox.org ([62.4.1.35]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aXzqQ-0004N6-MP for pgsql-general@postgresql.org; Mon, 22 Feb 2016 23:24:48 +0000 Received: by mail2.openmailbox.org (Postfix, from userid 1004) id 2D1122AC1730; Tue, 23 Feb 2016 00:24:43 +0100 (CET) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=openmailbox.org; s=openmailbox; t=1456183483; bh=0zxn62I10VHyZ0xpYiDKRNQt01wvWtD96i9iLKbQ/Ug=; h=Date:From:To:CC:Subject:References:In-Reply-To:From; b=ouWiaSQ+bzbdd4Zem0wInEEhgwlSeTAsQoKY40G6h8Qp1tKr43Icl8ub8crMjx5G0 3vAdwpDwZmeA5aUsOau/oVrBrdk2rsJQ1u+K/Lt3d40CLmWt4VjqKj67oF47M6523v SzgcYn6rr/+t1nOcszagclr4gbgsDQcNg2qON8Zg= X-Spam-Checker-Version: SpamAssassin 3.4.0 (2014-02-07) on openmailbox-b2 X-Spam-Level: X-Spam-Status: No, score=-2.0 required=5.0 tests=BAYES_00,DKIM_SIGNED, DKIM_VALID,DKIM_VALID_AU,HTML_MESSAGE,NO_RECEIVED,NO_RELAYS,URIBL_BLOCKED autolearn=no autolearn_force=no version=3.4.0 Message-ID: <56CB98AA.8040408@openmailbox.org> DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=openmailbox.org; s=openmailbox; t=1456183472; bh=0zxn62I10VHyZ0xpYiDKRNQt01wvWtD96i9iLKbQ/Ug=; h=Date:From:To:CC:Subject:References:In-Reply-To:From; b=OIYLTKCZOic+QfdG612uTJ+GuNaiIg2I2OPHD7fuPY/nbn/AQSpV4w+tGoruULz0q FLDBW5a8ZegVDJ+49hruJExK0V0mG3reNwIyt/rBvOmHDjE06kBvc4ZSF5+2BOUBVf +Mp230me9gM37txkVGq8Py3OePhFTGLe8YoOIo0o= Date: Mon, 22 Feb 2016 20:24:26 -0300 From: "Edson F. Lidorio" User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:31.0) Gecko/20100101 Icedove/31.8.0 MIME-Version: 1.0 To: Melvin Davidson , Zlatko Asenov CC: "David G. Johnston" , pgsql-general Subject: Re: Get the date of creation of objects in the database References: <56CB84F7.20803@openmailbox.org> <56cb8920.c74fc20a.c69fa.5153@mx.google.com> In-Reply-To: Content-Type: multipart/alternative; boundary="------------050800080400030100090902" X-Pg-Spam-Score: -2.0 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-general Precedence: bulk Sender: pgsql-general-owner@postgresql.org This is a multi-part message in MIME format. --------------050800080400030100090902 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit On 22-02-2016 19:42, Melvin Davidson wrote: > > On Mon, Feb 22, 2016 at 5:18 PM, Zlatko Asenov > > 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: [GENERAL] Get the date of creation of objects in the > database > > On Mon, Feb 22, 2016 at 3:00 PM, Edson F. Lidorio > >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 Listen11similar discussionat [1] [1] http://pgsql-hackers.postgresql.narkive.com/TQSHWw1l/proposal-store-timestamptz-of-database-creation-on-pg-database --------------050800080400030100090902 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit

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

On Mon, Feb 22, 2016 at 5:18 PM, Zlatko Asenov <zlatko.asenov@gmail.com> 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: [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> 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
 --------------050800080400030100090902--