Re: Can schemas be ordered regarding their creation time ? - Mailing list pgsql-admin

From Amador Alvarez
Subject Re: Can schemas be ordered regarding their creation time ?
Date
Msg-id 4FD0F2EF.4070302@d2.com
Whole thread Raw
In response to Re: Can schemas be ordered regarding their creation time ?  (hari.fuchs@gmail.com)
List pgsql-admin
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<aalvarez@d2.com>  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$$;
>
>

pgsql-admin by date:

Previous
From: Lonni J Friedman
Date:
Subject: Re: pg_basebackup blocking all queries with horrible performance
Next
From: Magnus Hagander
Date:
Subject: Re: pg_basebackup blocking all queries with horrible performance