Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 2762C9066CF for ; Thu, 7 Jun 2012 15:37:12 -0300 (ADT) Received: from mx2.d2.com ([66.251.81.121]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SchZz-0006LN-RO for pgsql-admin@postgresql.org; Thu, 07 Jun 2012 18:37:11 +0000 Received: from mxb.d2.com ([10.85.4.6]) by mx2.d2.com (8.13.8/8.13.8) with ESMTP id q57JWrIv009612 for ; Thu, 7 Jun 2012 12:33:07 -0700 X-ASG-Debug-ID: 1339094190-01d10a6c9720eb340002-ysJW5H Received: from mail01.d2.com ([172.16.66.171]) by mxb.d2.com with ESMTP id vQAW10GcwQ5zkPcB; Thu, 07 Jun 2012 11:36:30 -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 q57IT49d012927; Thu, 7 Jun 2012 11:29:04 -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); Thu, 7 Jun 2012 11:29:04 -0700 Message-ID: <4FD0F2EF.4070302@d2.com> Date: Thu, 07 Jun 2012 11:29:03 -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, hari.fuchs@gmail.com Subject: Re: Can schemas be ordered regarding their creation time ? References: <4FCEA2DF.3010904@d2.com> <877gvkc1a6.fsf@hf.protecting.net> <4FCFC13E.5040503@d2.com> <873967bm2e.fsf@hf.protecting.net> X-ASG-Orig-Subj: Re: [ADMIN] Can schemas be ordered regarding their creation time ? In-Reply-To: <873967bm2e.fsf@hf.protecting.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 07 Jun 2012 18:29:04.0253 (UTC) FILETIME=[6AB732D0:01CD44DB] X-Barracuda-Connect: UNKNOWN[172.16.66.171] X-Barracuda-Start-Time: 1339094190 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.20 X-Barracuda-Spam-Status: No, SCORE=0.20 using per-user scores of TAG_LEVEL=1000.0 QUARANTINE_LEVEL=1000.0 KILL_LEVEL=9.0 tests=BSF_SC7_SA298e X-Barracuda-Spam-Report: Code version 3.2, rules version 3.2.2.99220 Rule breakdown below pts rule name description ---- ---------------------- -------------------------------------------------- 0.20 BSF_SC7_SA298e Custom Rule SA298e X-Spam-Status: NO, score=-1.6 required=3.0 tests=ALL_TRUSTED,AWL,BAYES_20, RATWARE_GECKO_BUILD, UPPERCASE_25_50 autolearn=unavailable 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/24 X-Sequence-Number: 39615 Thanks a lot Hari, very resourceful, you have been very helpful. cheers, A.A. On 06/07/2012 12:47 AM, hari.fuchs@gmail.com wrote: > 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$$; > >