pg.ddx.io  pgsql-general@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Zlatko Asenov <zlatko.asenov@gmail.com>
To: David G. Johnston <david.g.johnston@gmail.com>
To: Edson F. Lidorio <edson@openmailbox.org>
Cc: pgsql-general <pgsql-general@postgresql.org>
Subject: Re: Get the date of creation of objects in the database
Date: Tue, 23 Feb 2016 00:18:02 +0200
Message-ID: <56cb8920.c74fc20a.c69fa.5153@mx.google.com> (raw)
In-Reply-To: <CAKFQuwaW4vnYbR5aVhG_YFExqMAkZzKpRLnBaZ-BqONvZPFNEA@mail.gmail.com>
References: <56CB84F7.20803@openmailbox.org>
	<CAKFQuwaW4vnYbR5aVhG_YFExqMAkZzKpRLnBaZ-BqONvZPFNEA@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-general>

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

-----Original Message-----
From: "David G. Johnston" <david.g.johnston@gmail.com>
Sent: β€Ž2/β€Ž23/β€Ž2016 0:14
To: "Edson F. Lidorio" <edson@openmailbox.org>
Cc: "pgsql-general" <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> 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.=

view thread (10+ messages)  latest in thread

Message-ID: <56cb8920.c74fc20a.c69fa.5153@mx.google.com>
Permalink:  ../56cb8920.c74fc20a.c69fa.5153@mx.google.com/
Also on:    postgresql.org/message-id/56cb8920.c74fc20a.c69fa.5153@mx.google.com

 · 

reply
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: zlatko.asenov@gmail.com, david.g.johnston@gmail.com, edson@openmailbox.org
  Subject: Re: Get the date of creation of objects in the database
  In-Reply-To: <56cb8920.c74fc20a.c69fa.5153@mx.google.com>

* 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