Interval formats in select and dump - Mailing list pgsql-general

Hi,

    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. Until now I have been working around this
by editing the dump by hand and adding the string "hours" after a "@ 0\t",
but I am sure there must be a more intelligent way. Any suggestions?

    IAC, is there some way of excluding the "@" in the interval field
in the output of a select statement?

    I am using European,Postgres datestyle and postgres is 7.1.3

Thanks and regards,
Gurunandan