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  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Interval formats in select and dump  ("arguile" <arguile@lucentstudios.com>)
Список 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 по дате отправления:

Предыдущее
От: Micah Yoder
Дата:
Сообщение: Re: Storing a tree
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Interval formats in select and dump