Debra,
> It will be tough redesigning the database to use a surrogate key,
> cause it
> links to other tables using this key and I can't lose this
> relationship.
OK. Just keep it in mind for the next database ;-)
> I ran the select query (looking for duplicate data) and the result
> returned
> 0 rows. I have also run this copy using just a few records that I
> know are
> unique with the same result.
>
> Unfortunately these fields do contain spaces and funny characters,
> could
> this be the problem??
Yes, it could be. Certain characters, such as \ and <tab> can cause
COPY to misbehave. Can you post your full tabledef, plus a few lines
of the COPY file?
-Josh Berkus
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh@agliodbs.com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco