Re: Get the date of creation of objects in the database - Mailing list pgsql-general

From Zlatko Asenov
Subject Re: Get the date of creation of objects in the database
Date
Msg-id 56cb8920.c74fc20a.c69fa.5153@mx.google.com
Whole thread Raw
In response to Re: Get the date of creation of objects in the database  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: Get the date of creation of objects in the database  (Melvin Davidson <melvin6925@gmail.com>)
List pgsql-general
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.

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Get the date of creation of objects in the database
Next
From: Tom Lane
Date:
Subject: Re: ERROR: cannot convert relation containing dropped columns to view