Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 6700B98F709 for ; Tue, 5 Jun 2012 21:23:38 -0300 (ADT) Received: from mx2.d2.com ([66.251.81.121]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Sc42D-0006SX-AO for pgsql-admin@postgresql.org; Wed, 06 Jun 2012 00:23:37 +0000 Received: from mxb.d2.com ([10.85.4.6]) by mx2.d2.com (8.13.8/8.13.8) with ESMTP id q561JJPT006592 for ; Tue, 5 Jun 2012 18:19:33 -0700 X-ASG-Debug-ID: 1338942176-01d10a6c961fe8c70001-ysJW5H Received: from mail01.d2.com ([172.16.66.171]) by mxb.d2.com with ESMTP id qszGzGlFwQsWUjDr for ; Tue, 05 Jun 2012 17:22:56 -0700 (PDT) X-Barracuda-Envelope-From: aalvarez@d2.com Received: from exbew2k3-02.d2.com (exbew2k3-02 [10.78.2.16]) by mail01.d2.com (8.13.8/8.13.8/Debian-3) with ESMTP id q560Mup9000753 for ; Tue, 5 Jun 2012 17:22:56 -0700 Received: from [10.126.2.220] ([10.126.2.220] RDNS failed) by exbew2k3-02.d2.com with Microsoft SMTPSVC(6.0.3790.3959); Tue, 5 Jun 2012 17:22:55 -0700 Message-ID: <4FCEA2DF.3010904@d2.com> Date: Tue, 05 Jun 2012 17:22:55 -0700 From: Amador Alvarez User-Agent: Mozilla/5.0 (X11; U; Linux i686 (x86_64); en-US; rv:1.9.2.27) Gecko/20120216 Lightning/1.0b2 Thunderbird/3.1.19 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Can schemas be ordered regarding their creation time ? Content-Type: text/plain; charset=ISO-8859-1; format=flowed X-ASG-Orig-Subj: Can schemas be ordered regarding their creation time ? Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 06 Jun 2012 00:22:56.0030 (UTC) FILETIME=[8503C3E0:01CD437A] X-Barracuda-Connect: UNKNOWN[172.16.66.171] X-Barracuda-Start-Time: 1338942176 X-Barracuda-URL: http://10.85.4.6:8000/cgi-mod/mark.cgi X-Virus-Scanned: by bsmtpd at d2.com X-Barracuda-Spam-Score: 0.00 X-Barracuda-Spam-Status: No, SCORE=0.00 using per-user scores of TAG_LEVEL=1000.0 QUARANTINE_LEVEL=1000.0 KILL_LEVEL=9.0 tests= X-Barracuda-Spam-Report: Code version 3.2, rules version 3.2.2.99058 Rule breakdown below pts rule name description ---- ---------------------- -------------------------------------------------- X-Spam-Status: NO, score=-1.3 required=3.0 tests=ALL_TRUSTED,AWL,BAYES_40, RATWARE_GECKO_BUILD autolearn=ham version=3.2.4 X-Spam-Checker-Version: SpamAssassin 3.2.4 (2008-01-01) on mx2.d2.com X-Pg-Spam-Score: -0.5 (/) X-Archive-Number: 201206/6 X-Sequence-Number: 39597 Hi there, 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. Thanks in advance, A.A.