Re: Timestamp input + copy - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Timestamp input + copy
Date
Msg-id 1091085872.27159.18.camel@localhost.localdomain
Whole thread Raw
In response to Re: Timestamp input + copy  ("Kevin Bartz" <kbartz@loyaltymatrix.com>)
List 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 by date:

Previous
From: reina_ga@hotmail.com (Tony Reina)
Date:
Subject: Re: Win32 binary
Next
From: "Antony Paul"
Date:
Subject: Need info on performance tuning.