"Daniel Verite" <daniel@manitou-mail.org> writes:
> I think it would valuable to have at least a default format that
> doesn't include the sub-second precision, since it typically adds 7
> characters that enlarge output columns in a way that is generally
> useless to the human eyes. Do other users agree with that?
If you think it's useless, just store your timestamps in a timestamp(0)
column.
regards, tom lane