I'm trying to generate a comment on all my changes - so I know when they were
completed.
Does anybody have anything that does this.
I think the psql script is something like
d1gp1= \set currtime `date '+20%y-%m-%d %H:%M:%S'`
d1gp1= \echo :currtime
2010-10-06 10:01:51
d1gp1= comment on index
2010/10/6 Little, Douglas douglas.lit...@orbitz.com
Unfortunately the variable doesn’t get replaced due to the quotes.
COMMENT ON INDEX mdm_mart_tbls.mdm_gotoastcampaignevt_pk IS 'created by
dwda-1618 on :currtime';
I’ve tried various options, 2,3,4 quotes. Concatenation, Building