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 ? 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
Дата:
FAQ