From: | "Samuel A(dot) Mullen" <smullen(at)oppunl(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | COPY Question |
Date: | 2000-04-21 14:30:02 |
Message-ID: | 390065EA.187361C3@oppunl.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm trying to load a table from a flat file using the copy command from
within PG.
Table:
+----------------------------------+----------------------------------+-------+
| Field | Type |
Length|
+----------------------------------+----------------------------------+-------+
| dup_id | int4 not null default nextval('"
| 4 |
| dup_group | int4
| 4 |
| company | varchar()
| 0 |
| matchcode | varchar()
| 0 |
| new_matchcode | varchar()
| 0 |
| gender | char()
| 1 |
| lastnm | varchar()
| 0 |
| firstnm | varchar()
| 0 |
| address | varchar()
| 0 |
| state | char()
| 2 |
| postal_code | varchar()
| 0 |
| life_paid | float4
| 4 |
| life_refund | float4
| 4 |
| ytd_paid | float4
| 4 |
+----------------------------------+----------------------------------+-------+
Index: duplicates_pkey
Copy Command:
copy duplicates from '$SOME_DIRECTORY/cap_dups' using delimiters '|';
Example Record to be inserted:
|7984|cap|99830MTIN557|99830.PBKS557.MRMNT.MBRRST|M|ROBERTS|MATIN|PO BOX
557|AK|99830|0|0|0
Error:
ERROR: Cannot insert a duplicate key into a unique index
As you can see I'm delimiting the fields with a '|' character. You will
also notice that there is no field 1. I was hoping that I could leave
that blank and the sequence automatically fill in the PKEY. Does this
not work?
Any help to why this fail is appreciated.
Samuel Mullen
--
_____________________
/ Samuel A. Mullen \
| Programmer Analyst |_______________________________________________
| Opportunities Unl. | They also do no iniquity: they walk in his \
\_____________________/| ways. |
| Psalms 119:2 |
\_______________________________________________/
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2000-04-21 15:10:01 | Re: COPY Question |
Previous Message | Brett W. McCoy | 2000-04-21 14:24:09 | Re: PG Problems |