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

Поиск
Список
Период
Сортировка
От Zlatko Asenov
Тема Re: Get the date of creation of objects in the database
Дата
Msg-id 56cb8920.c74fc20a.c69fa.5153@mx.google.com
обсуждение исходный текст
Ответ на Re: Get the date of creation of objects in the database  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: Get the date of creation of objects in the database  (Melvin Davidson <melvin6925@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Get the date of creation of objects in the database
Следующее
От: Tom Lane
Дата:
Сообщение: Re: ERROR: cannot convert relation containing dropped columns to view