Re: Timestamp input + copy

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Timestamp input + copy
Дата
Msg-id 1091085872.27159.18.camel@localhost.localdomain
обсуждение исходный текст
Ответ на Re: Timestamp input + copy  ("Kevin Bartz" <kbartz@loyaltymatrix.com>)
Список pgsql-general
On Wed, 2004-07-28 at 19:25, Kevin Bartz wrote:
> Thanks, guys. sed took a couple hours, but it's all done now, and the data
> are loaded. I still like Postgres!

ya know, there's an easier way (imnsho):

just import it into a text field, then update the real field with

update table tablename set realfield = substring(tempfield,1,20)

Not sure it'd be any faster, but hey, it's pretty simple to do.


В списке pgsql-general по дате отправления:

Предыдущее
От: reina_ga@hotmail.com (Tony Reina)
Дата:
Сообщение: Re: Win32 binary
Следующее
От: "Antony Paul"
Дата:
Сообщение: Need info on performance tuning.