Re: [GENERAL] Get the date of creation of objects in the database

2016-02-22 Thread Stephen Frost
* Tom Lane (t...@sss.pgh.pa.us) wrote: > Stephen Frost writes: > > At least on a first blush look through the threads linked from such a > > search, I'm unimpressed by the arguments against and note that there are > > quite a few arguments for. > > I think you missed the

Re: [GENERAL] Get the date of creation of objects in the database

2016-02-22 Thread Tom Lane
Stephen Frost writes: > At least on a first blush look through the threads linked from such a > search, I'm unimpressed by the arguments against and note that there are > quite a few arguments for. I think you missed the worries around what dump/reload semantics would be. >

Re: [GENERAL] Get the date of creation of objects in the database

2016-02-22 Thread Stephen Frost
David, * David G. Johnston (david.g.johns...@gmail.com) wrote: > 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. What on the local filesystem would help here..? All you

Re: [GENERAL] Get the date of creation of objects in the database

2016-02-22 Thread Adrian Klaver
On 02/22/2016 03:24 PM, Edson F. Lidorio wrote: + 1 Listen11similar discussionat [1] [1] http://pgsql-hackers.postgresql.narkive.com/TQSHWw1l/proposal-store-timestamptz-of-database-creation-on-pg-database Where the above leads to is implementing a version control system inside the

Re: [GENERAL] Get the date of creation of objects in the database

2016-02-22 Thread Edson F. Lidorio
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.

Re: [GENERAL] Get the date of creation of objects in the database

2016-02-22 Thread Melvin Davidson
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

Re: [GENERAL] Get the date of creation of objects in the database

2016-02-22 Thread Zlatko Asenov
You may find useful a SIEM to record activity like this. -Original Message- From: "David G. Johnston" Sent: ‎2/‎23/‎2016 0:14 To: "Edson F. Lidorio" Cc: "pgsql-general" Subject: Re: [GENERAL] Get the date

Re: [GENERAL] Get the date of creation of objects in the database

2016-02-22 Thread David G. Johnston
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

Re: [GENERAL] Get the date of creation of objects in the database

2016-02-22 Thread Adrian Klaver
On 02/22/2016 02: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. AFAIK that is not recorded by default. If you are using Postgres 9.3+ you could roll your own audit system, going forward,

[GENERAL] Get the date of creation of objects in the database

2016-02-22 Thread Edson F. Lidorio
Hello, How to get the date of creation of objects in batabase? For example: The date of creation of tables and trigger. Thank you; Edson -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: