Message-ID: <4FCFC13E.5040503@d2.com>
Date: Wed, 06 Jun 2012 13:44:46 -0700
From: Amador Alvarez <aalvarez@d2.com>
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: Re: Can schemas be ordered regarding their creation time
 ?
References: <4FCEA2DF.3010904@d2.com> <877gvkc1a6.fsf@hf.protecting.net>
In-Reply-To: <877gvkc1a6.fsf@hf.protecting.net>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit


Thanks hary and Matthias,
It is a very good idea, however the schema names are meaningful and not 
allowed to be attached to a date.
Regarding the comment solution ("COMMENT ON SCHEMA x IS 'y'"), it sounds 
great and I tried to run different examples without happy ending as 'y' 
must be a literal string.

I ran commands like these :

comment on schema users is select to_char(current_timestamp,'DD Mon YYYY');

comment on schema users is select 
quote_literal(to_char(current_timestamp,'DD Mon YYYY'));

..... and even simple concatenated strings :  comment on schema users is 
'a'||'b';
                                                                       
ERROR:  syntax error at or near "||"
                                                                       
LINE 1: comment on schema users is 'a'||'b';

... and even with a function returning a text ... : (


Any idea on doing ("COMMENT ON SCHEMA x IS 'y'") as 'y' variable?


Thanks again,
I appreciate it a lot,
A.A.


I have been trying a lot of different options to do this :

"COMMENT ON SCHEMA x IS 'y'".


On 06/06/2012 01:06 AM, hari.fuchs@gmail.com wrote:
> Amador Alvarez<aalvarez@d2.com>  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'".
>
>