RE: COPY again...

If the file is truly CSV (comma separated values), you might want to change
DELIMITERS '\t' to DELIMITERS ','...  Otherwise, include a couple of lines
of data...

Robert Creager
Senior Software Engineer
Client Server Library
303.673.2365 V
303.661.5379 F
888.912.4458 P
StorageTek
INFORMATION made POWERFUL



> -----Original Message-----
> From: Tony Grant [mailto:tony@animaproductions.com]
> Sent: Wednesday, March 07, 2001 7:34 AM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] COPY again...
>
>
> 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