On Nov 10, 2010, at 2:55 PM, pasman pasmański wrote: > How to add comment on table with calculated value ? > > COMMENT ON TABLE test IS 'Updated ' || current_date;
You can create function to do that. Or If you are using PG9.0, then DO would help you, as given below: do $$ Declare t text; begin t:='COMMENT ON TABLE TEST_COPY IS '||''''||'TEST WITH '||current_date||''''; execute t; end; $$ language plpgsql; Thanks & Regards, Vibhor Kumar -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
