2010/10/6 Little, Douglas
>
>
>
>
> 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 the
> entire st
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
