Re: Can schemas be ordered regarding their creation time ?
От
Amador Alvarez
Тема
Re: Can schemas be ordered regarding their creation time
?
Дата
Msg-id
4FD0F2EF.4070302@d2.com
Ответ на
Re: Can schemas be ordered regarding their creation time ? (hari.fuchs@gmail.com)
Список
Дерево обсуждения
Re: Can schemas be ordered regarding their creation time ? hari.fuchs@gmail.com
Re: Can schemas be ordered regarding their creation time
? Amador Alvarez <aalvarez@d2.com>
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$$;
>
>
В списке pgsql-admin по дате отправления
От: Lonni J Friedman
Дата:
От: Magnus Hagander
Дата: