2010/11/10 pasman pasmański <pasman(dot)p(at)gmail(dot)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