From: | "Patrick Hatcher" <PHatcher(at)macys(dot)com> |
---|---|
To: | "Fred Soustra <fredboard" <fredboard(at)sus(dot)mcgill(dot)ca> |
Cc: | pgsql-novice(at)postgresql(dot)org, pgsql-novice-owner(at)postgresql(dot)org |
Subject: | Re: Problems with copy |
Date: | 2003-03-19 18:00:23 |
Message-ID: | OF956C0D3F.D9A2893D-ON88256CEE.0062BC32-88256CEE.006353E4@fds.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
I think this is correct:
copy client(field1,field2,fieldn) from
'/path/client.del' using
delimiters ',';
HTH
Patrick Hatcher
Fred Soustra
<fredboard(at)sus(dot)mcgill(dot)c To: pgsql-novice(at)postgresql(dot)org
a> cc:
Sent by: Subject: [NOVICE] Problems with copy
pgsql-novice-owner(at)post
gresql.org
03/14/2003 12:40 AM
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 | Tom Lane | 2003-03-19 18:03:11 | Re: pg_dump ,pg_restore problem |
Previous Message | Joe Conway | 2003-03-19 15:01:23 | Re: Problems using palloc in postgresql user C functions |