Re: How to import a CSV file (originally from Excel) - Mailing list pgsql-general

From Craig White
Subject Re: How to import a CSV file (originally from Excel)
Date
Msg-id 1144887243.5828.96.camel@lin-workstation.azapple.com
Whole thread Raw
In response to Re: How to import a CSV file (originally from Excel)  ("Magnus Hagander" <mha@sollentuna.net>)
List pgsql-general
On Wed, 2006-04-12 at 17:57 +0200, Magnus Hagander wrote:
> > > \copy "Flight Traffic" from yourfile.csv delimiter as ','
> > csv quote as
> > > '"'
> > >
> > > (might need some adaption, of course)
> > >
> > >
> > > Loading 45,000 lines is trivial for copy, it shouldn't take
> > noticable
> > > time at all.
> > ----
> > along these lines - can I do something similar (CSV file) but
> > 'update' 2 or 3 columns?
>
> I'd use COPY to a temp table, then run a normal UPDATE on that.
----
is that a pg 8.x thing? I'm using 7.4.x (RHEL)

th-db_development=# \copy "clients_temp" from representatives.csv
delimiter as ',' csv quote as '"'
ERROR:  syntax error at or near "CSV" at character 53
LINE 1: ...PY "clients_temp" FROM STDIN USING DELIMITERS ',' CSV
QUOTE ...
                                                             ^
\copy: ERROR:  syntax error at or near "CSV" at character 53

Craig


pgsql-general by date:

Previous
From: Ryan
Date:
Subject: Initdb problem installing 8.1.3-1 on winXP
Next
From: "Merlin Moncure"
Date:
Subject: Re: Leverage your PostgreSQL V8.1 skills to learn DB2