Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125])
	by mail.postgresql.org (Postfix) with ESMTP id 0A34B98F709
	for <pgsql-admin@postgresql.org>; Tue,  5 Jun 2012 21:43:49 -0300 (ADT)
Received: from sss.pgh.pa.us ([66.207.139.130])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <tgl@sss.pgh.pa.us>) id 1Sc4Lk-0006kG-5Q
	for pgsql-admin@postgresql.org; Wed, 06 Jun 2012 00:43:49 +0000
Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1])
	by sss.pgh.pa.us (8.14.5/8.14.5) with ESMTP id q560hYJ9004121;
	Tue, 5 Jun 2012 20:43:34 -0400 (EDT)
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Amador Alvarez <aalvarez@d2.com>
cc: pgsql-admin@postgresql.org
Subject: Re: Can schemas be ordered regarding their creation time ?
In-reply-to: <4FCEA2DF.3010904@d2.com>
References: <4FCEA2DF.3010904@d2.com>
Comments: In-reply-to Amador Alvarez <aalvarez@d2.com>
	message dated "Tue, 05 Jun 2012 17:22:55 -0700"
Date: Tue, 05 Jun 2012 20:43:34 -0400
Message-ID: <4120.1338943414@sss.pgh.pa.us>
X-Pg-Spam-Score: -1.9 (-)
X-Archive-Number: 201206/7
X-Sequence-Number: 39598

Amador Alvarez <aalvarez@d2.com> writes:
> I would like to know if it is possible to get the date when the 
> different schemas were created, as I want to write an script to dump 
> only the latest schemas, the latest month created schemas for instance.

No, sorry, Postgres does not track creation time of database objects.

			regards, tom lane