Re: Comments on tables
От
Szymon Guz
Тема
Re: Comments on tables
Дата
Msg-id
AANLkTi=M-M7=d5uqoBqEQR8V6EgBrdFr8cKiu-3CdNKF@mail.gmail.com
Ответ на
Comments on tables (pasman pasmański)
Список
Дерево обсуждения
Re: Comments on tables Pasman <pasman.p@gmail.com>
2010/11/10 pasman pasmański <pasman.p@gmail.com>
Hello.
How to add comment on table with calculated value ?
COMMENT ON TABLE test IS 'Updated ' || current_date;
not works ...
Hi,
I'd suggest something like this:
do $$
begin
execute 'COMMENT ON TABLE test_count is ''Updated ' || current_date || '''';
end$$;
This would run on postgres from 9.0, for earlier versions, you could always write similar function.
regards
Szymon
В списке pgsql-general по дате отправления
