Interval formats in select and dump
| От | Gurunandan R. Bhat |
|---|---|
| Тема | Interval formats in select and dump |
| Дата | |
| Msg-id | Pine.LNX.4.33.0111111026060.1679-100000@suman.greenfields.universe обсуждение исходный текст |
| Ответы |
Re: Interval formats in select and dump
Re: Interval formats in select and dump |
| Список | 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
В списке pgsql-general по дате отправления: