Re: when was a db/schema created ?

On Mon, Sep 17, 2012 at 2:16 PM, Gauthier, Dave <dave.gauthier@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 database';

Then check the creation time of the directory with that OID in your
$PGDATA directory, under ./base/.

Josh