Re: Can schemas be ordered regarding their creation time ?

[Amador Alvarez <aalvarez@xxxxxx>]

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

cheers,
A.A.

On 06/07/2012 12:47 AM, hari.fuchs@xxxxxxxxx wrote:
> Amador Alvarez<aalvarez@xxxxxx>  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$$;

--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin