Kevin Murphy <murphy(at)genome(dot)chop(dot)edu> writes:
> lastupdated timestamp without time zone DEFAULT
> ('now'::text)::timestamp(6) with time zone NOT NULL
> For my personal edification, I'd like to understand what's going on with
> that first one!
It's what the PG grammar converts CURRENT_TIMESTAMP(6) into.
(We really ought to do a better job of hiding that from the user...)
regards, tom lane