Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 82F4898F709 for ; Tue, 5 Jun 2012 21:58:29 -0300 (ADT) Received: from mx2.d2.com ([66.251.81.121]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Sc4Zw-0006ym-Mn for pgsql-admin@postgresql.org; Wed, 06 Jun 2012 00:58:29 +0000 Received: from mxb.d2.com ([10.85.4.6]) by mx2.d2.com (8.13.8/8.13.8) with ESMTP id q561sVZo007867 for ; Tue, 5 Jun 2012 18:54:31 -0700 X-ASG-Debug-ID: 1338944288-01d10a6c961fec720001-ysJW5H Received: from mail01.d2.com ([172.16.66.171]) by mxb.d2.com with ESMTP id CZ9OKl8JtA7jQ8rK; Tue, 05 Jun 2012 17:58:08 -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 q560w8nP001883; Tue, 5 Jun 2012 17:58:08 -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:58:07 -0700 Message-ID: <4FCEAB1F.8090006@d2.com> Date: Tue, 05 Jun 2012 17:58:07 -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: Tom Lane CC: pgsql-admin@postgresql.org Subject: Re: Can schemas be ordered regarding their creation time ? References: <4FCEA2DF.3010904@d2.com> <4120.1338943414@sss.pgh.pa.us> X-ASG-Orig-Subj: Re: [ADMIN] Can schemas be ordered regarding their creation time ? In-Reply-To: <4120.1338943414@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 06 Jun 2012 00:58:07.0981 (UTC) FILETIME=[6FD5E9D0:01CD437F] X-Barracuda-Connect: UNKNOWN[172.16.66.171] X-Barracuda-Start-Time: 1338944288 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.99060 Rule breakdown below pts rule name description ---- ---------------------- -------------------------------------------------- X-Spam-Status: NO, score=-1.8 required=3.0 tests=ALL_TRUSTED,AWL,BAYES_05, 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: -1.9 (-) X-Archive-Number: 201206/8 X-Sequence-Number: 39599 Thanks Tom, I will figure out then how to add a newly created schema to the schema-list to be backed up (dumped) but not directly as i expected. Cheers, A.A. On 06/05/2012 05:43 PM, Tom Lane wrote: > Amador Alvarez 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