Re: Timestamp input + copy

Thanks for your reply, Scott. A variation on that suggestion does work very
well for me.

Kevin

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Scott Marlowe
Sent: Thursday, July 29, 2004 12:25 AM
To: Kevin Bartz
Cc: 'Tom Lane'; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Timestamp input + copy

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.


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster