From: | "Adam Lang" <aalang(at)rutgersinsurance(dot)com> |
---|---|
To: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | copy from |
Date: | 2000-08-14 20:34:23 |
Message-ID: | 02b701c0062f$081e31c0$330a0a0a@Adam |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
I need additional help involving the copy from command
I have a database with several fields: id, name, address, zip
id is the primary key and I use nextval to get a value.
The file I want to upload is in comma separated value, that does not have a
primry key (or an id) field.
How would I use copy from and assign the correct id number?
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
From | Date | Subject | |
---|---|---|---|
Next Message | Madel, Kurt | 2000-08-14 20:40:09 | Creating A Rule to Increment a class size when a student adds tha t class to their schedule |
Previous Message | Jesus Aneiros | 2000-08-14 19:24:16 | Re: select an entry with a NULL date field |