Problems with copy - Mailing list pgsql-novice

From Fred Soustra
Subject Problems with copy
Date
Msg-id 20030314084045.GA21634@sus.mcgill.ca
Whole thread Raw
Responses Re: Problems with copy  ("Patrick Hatcher" <PHatcher@macys.com>)
List pgsql-novice
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

pgsql-novice by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: [SQL] SERIAL does not ROLLBACK
Next
From: "IT Contractors (P) Ltd"
Date:
Subject: postgreSQL - problem with connection