From: | "Duncan Adams (DNS)" <duncan(dot)adams(at)vcontractor(dot)co(dot)za> |
---|---|
To: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Problems with copy |
Date: | 2003-03-20 06:26:46 |
Message-ID: | 034A824BAA3FBA4CA0CBEF1031A02F35014C3D46@zablv02001.vodacom.corp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I guess u could create a temp table, copy the info to that and then use sql to extract the information that u what.
-----Original Message-----
From: Fred Soustra [mailto:fredboard(at)sus(dot)mcgill(dot)ca]
Sent: Friday, March 14, 2003 10:41 AM
To: pgsql-novice(at)postgresql(dot)org
Subject: [NOVICE] Problems with copy
Hi, I am trying to import data from a cvs, file using copy the only problem i
have is that the first field of my table is automatically generated.
So I wanted to know if there is a way to select which columns copy should use.
the command i am running is the following
copy client from
'/path/client.del' using
delimiters ',';
Can i get it to do something like
import from file foo insert into (col2,col3 ...) ?
Thanx
Fred
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
message can get through to the mailing list cleanly
From | Date | Subject | |
---|---|---|---|
Next Message | Ben Clewett | 2003-03-20 13:12:44 | User check |
Previous Message | Tom Lane | 2003-03-20 04:10:20 | Re: permission denied |