"Gurunandan R. Bhat" <grbhat(at)exocore(dot)com> writes:
> Whenever I dump tables with an interval field which is zero,
> pg_dump writes it as "@ 0" rather than "@ 0 hours" (which is the case with
> intervals whose values are not zero). When this happens, the restore
> always dies with a format error.
This seems to be fixed in current sources (7.2beta). '@ 0' should be
legal input, and is accepted now.
> IAC, is there some way of excluding the "@" in the interval field
> in the output of a select statement?
Don't use Postgres datestyle?
regards, tom lane