X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 006B69FB3A9 for ; Wed, 20 Sep 2006 12:52:01 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 82775-09 for ; Wed, 20 Sep 2006 12:51:51 -0300 (ADT) X-Greylist: delayed 00:06:39.935172 by SQLgrey- Received: from web58313.mail.re3.yahoo.com (web58313.mail.re3.yahoo.com [68.142.236.166]) by postgresql.org (Postfix) with SMTP id 79B529FB38C for ; Wed, 20 Sep 2006 12:51:51 -0300 (ADT) Received: (qmail 76449 invoked by uid 60001); 20 Sep 2006 15:45:09 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=DK1//ZFwxyv4MjmmOOAyK31jRDttaWsymHjR50benVH5vEJalp7+xdZ9rhOzMzGlcg3Rv+VxAvrdSKWGtQjCBslZIE8ykoGJmGWXCaKD9pNxz09dvgJrgutMCPNPsPgmeLPtLJBUZmmcGk73ckiLM2hTdb2UEqE8HQULzISu0GU= ; Message-ID: <20060920154509.76447.qmail@web58313.mail.re3.yahoo.com> Received: from [129.165.226.2] by web58313.mail.re3.yahoo.com via HTTP; Wed, 20 Sep 2006 08:45:09 PDT Date: Wed, 20 Sep 2006 08:45:09 -0700 (PDT) From: Jessica Richard Subject: how to check the creation date of a postgres database? To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-2145148756-1158767109=:74849" Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.852 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS, HTML_40_50, HTML_MESSAGE X-Spam-Level: *** X-Archive-Number: 200609/209 X-Sequence-Number: 23123 --0-2145148756-1158767109=:74849 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit \l and \l+ show only the database name, owner and description. select * from pg_database does not have date info, either. I would like to know when each of my databases were created. Thanks, Jessica --------------------------------- Get your own web address for just $1.99/1st yr. We'll help. Yahoo! Small Business. --0-2145148756-1158767109=:74849 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit \l and  \l+ show only the database name, owner and description.
select * from pg_database does not have date info, either.

I would like to know when each of my databases were created.

Thanks,
Jessica


Get your own web address for just $1.99/1st yr. We'll help. Yahoo! Small Business. --0-2145148756-1158767109=:74849--