Re: Can schemas be ordered regarding their creation time ?

From: Amador Alvarez <aalvarez(at)d2(dot)com>
To: pgsql-admin(at)postgresql(dot)org, hari(dot)fuchs(at)gmail(dot)com
Subject: Re: Can schemas be ordered regarding their creation time ?
Date: 2012-06-07 18:29:03
Message-ID: 4FD0F2EF.4070302@d2.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Thanks a lot Hari,
very resourceful, you have been very helpful.

cheers,
A.A.

On 06/07/2012 12:47 AM, hari(dot)fuchs(at)gmail(dot)com wrote:
> Amador Alvarez<aalvarez(at)d2(dot)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$$;
>
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Magnus Hagander 2012-06-07 19:40:45 Re: pg_basebackup blocking all queries with horrible performance
Previous Message Lonni J Friedman 2012-06-07 18:04:53 Re: pg_basebackup blocking all queries with horrible performance