| 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 |