Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id CDBC3779694 for ; Thu, 7 Jun 2012 04:47:52 -0300 (ADT) Received: from plane.gmane.org ([80.91.229.3]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1ScXRe-0006ae-L7 for pgsql-admin@postgresql.org; Thu, 07 Jun 2012 07:47:51 +0000 Received: from list by plane.gmane.org with local (Exim 4.69) (envelope-from ) id 1ScXRO-0000Fb-1A for pgsql-admin@postgresql.org; Thu, 07 Jun 2012 09:47:34 +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 ; Thu, 07 Jun 2012 09:47:33 +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 ; Thu, 07 Jun 2012 09:47:33 +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: Thu, 07 Jun 2012 09:47:21 +0200 Lines: 10 Message-ID: <873967bm2e.fsf@hf.protecting.net> References: <4FCEA2DF.3010904@d2.com> <877gvkc1a6.fsf@hf.protecting.net> <4FCFC13E.5040503@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:dZF7q+wqh79D169Y2mE3j8aVAn8= X-Pg-Spam-Score: -1.0 (-) X-Archive-Number: 201206/20 X-Sequence-Number: 39611 Amador Alvarez writes: > Any idea on doing ("COMMENT ON SCHEMA x IS 'y'") as 'y' variable? You could use PL/pgSQL's "EXECUTE" for that: DO $$BEGIN EXECUTE 'COMMENT ON SCHEMA myschema IS ''Created ' || current_timestamp || ''''; END$$;