Re: Timestamp input + copy

From: "Scott Marlowe" <smarlowe(at)qwest(dot)net>
To: "Kevin Bartz" <kbartz(at)loyaltymatrix(dot)com>
Cc: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org
Subject: Re: Timestamp input + copy
Date: 2004-07-29 07:24:32
Message-ID: 1091085872.27159.18.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Antony Paul 2004-07-29 08:12:18 Need info on performance tuning.
Previous Message Scott Marlowe 2004-07-29 07:16:29 Re: altering a table to set serial function