Problems with copy

From: Fred Soustra <fredboard(at)sus(dot)mcgill(dot)ca>
To: pgsql-novice(at)postgresql(dot)org
Subject: Problems with copy
Date: 2003-03-14 08:40:45
Message-ID: 20030314084045.GA21634@sus.mcgill.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Niclas Hedell 2003-03-14 10:34:35 Re: get the oid
Previous Message Joe Conway 2003-03-14 05:36:03 Re: Postgre User Privileges table