Thread

RE: COPY again...

Creager, Robert S <creagrs@louisville.stortek.com> — 2001-03-12T21:08:35Z

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