2010/11/10 pasman pasmański <pasma...@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
