Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 06E571179B40 for ; Wed, 6 Jun 2012 05:07:03 -0300 (ADT) Received: from plane.gmane.org ([80.91.229.3]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1ScBGf-0003Uc-7N for pgsql-admin@postgresql.org; Wed, 06 Jun 2012 08:07:01 +0000 Received: from list by plane.gmane.org with local (Exim 4.69) (envelope-from ) id 1ScBGN-0006Pn-Ce for pgsql-admin@postgresql.org; Wed, 06 Jun 2012 10:06:43 +0200 Received: from static.187.232.9.176.clients.your-server.de ([176.9.232.187]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 06 Jun 2012 10:06:43 +0200 Received: from hari.fuchs by static.187.232.9.176.clients.your-server.de with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 06 Jun 2012 10:06:43 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-admin@postgresql.org From: hari.fuchs@gmail.com Subject: Re: Can schemas be ordered regarding their creation time ? Date: Wed, 06 Jun 2012 10:06:25 +0200 Lines: 10 Message-ID: <877gvkc1a6.fsf@hf.protecting.net> References: <4FCEA2DF.3010904@d2.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@dough.gmane.org X-Gmane-NNTP-Posting-Host: static.187.232.9.176.clients.your-server.de X-Archive: encrypt X-PGP-Fingerprint: 09 4E C4 A2 B2 C5 33 1A 79 80 5D 39 BD 9B 89 39 Face: iVBORw0KGgoAAAANSUhEUgAAADAAAAAwBAMAAAClLOS0AAAAAXNSR0IArs4c6QAAABVQTFRFz5WF X0ZB9ObgFhEQl2ti/////v/+DXadyAAAAAFiS0dEAIgFHUgAAAAJcEhZcwAACxMAAAsTAQCanBgA AAAHdElNRQfcBRIQBAd99pVHAAABs0lEQVQ4y12UTXPCIBCGsUXPXaG522rPRtI7jFvP1k44ezD5 /z+hu2wgxB0zGJ7ZrzcLqi829P0YZSVTZT9+6AB2w/+GBbg7tu4wuWcQ905sK5GKx81MwG0WIO7y vjtVIFYOrhv6YQYPN9ulCjW+VuBYgSoS2WEC1O0cqaWnicXjk7cMAP3AuNNYkp8dgEWLgAjg2lLV zbS0r7xSivQyKYkAckAlhgTWBbRL8JPBVYBPIBjXFMCpBegEYg4lQGWPUymXgC8A3HHMgBrLQMMS mHYiwYHrMtizFMlHAxVoupxj5yiH5jSBsoE5ZvAwgMmH9GCPt9KHscHCCqgiWoPZZnA3Fj3ph8Gy jAvguWkEBjiDm7GpUpukRNPQlE592CSTD5hK/ingnAB4lPVStAppw6rUi4YNDYiAlYR6oWgMDsMU qt8lEHwqV2/ngXuAlIvIS1NNO3gvgPt8Boja07MEv5YBO2mptgIkLWtCy6E+nCQGigUY6zMIKVYC 28Xh/KM4XnsekuWp7Rlwdnh/BsDdFYfqZmj5YyB8y41RgSvlp3rlyojDDEgwmp319DJWIJLuX0MG //igAGCKkEYtAAAAAElFTkSuQmCC User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.2 (gnu/linux) Cancel-Lock: sha1:+R8ZgJ5UGHo3WSQyLlEbD6f5knY= X-Pg-Spam-Score: 1.7 (+) X-Archive-Number: 201206/10 X-Sequence-Number: 39601 Amador Alvarez writes: > 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. You could attach the creation date to the schema name or use "COMMENT ON SCHEMA x IS 'y'".