Re: COPY again...

Hi Tony
These things can get on ur nerves and it happened in my case too..

In my case the data simply didnt load into the tables becasue the
primary keys which were being referenced in the csv file were not
present in the file. Thus it never inserted any rows in thetable..

Also even if part of ur feed is incorrect the entire csv file will be
rejected without any reason being displayed..

U will have to sort this problems out by going thru samples of ur csv
file..

Hope this is of some help

Anand
On Wed, Mar 07, 2001 at 03:34:24PM +0100, Tony Grant wrote:
>Gets me every time this one...
>
>COPY entreprise FROM '/home/pgsql/data/ENTREP_Tony.csv' USING DELIMITERS
>'\t';
>
>gives
>
>No data returned
>
>What is wrong with my data file - .csv file from Gnumeric export?
>
>Cheers
>
>Tony Grant
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/users-lounge/docs/faq.html