[GENERAL] when was a db/schema created ?

2012-09-17 Thread Gauthier, Dave
Is there a way to determine when a DB was created (create database...)? Thanks in advance.

Re: [GENERAL] when was a db/schema created ?

2012-09-17 Thread Fabrízio de Royes Mello
2012/9/17 Gauthier, Dave dave.gauth...@intel.com Is there a way to determine when a DB was created (create database...)?** ** Thanks in advance. Dear Dave, You can configure the log_statement [1] GUC to log DDL statements. Regards, [1]

Re: [GENERAL] when was a db/schema created ?

2012-09-17 Thread Josh Kupershmidt
On Mon, Sep 17, 2012 at 2:16 PM, Gauthier, Dave dave.gauth...@intel.com wrote: Is there a way to determine when a DB was created (create database...)? If you don't have the CREATE DATABASE statement in your logs, you could try SELECT oid FROM pg_database WHERE datname = 'name of your