From: | "Creager, Robert S" <CreagRS(at)LOUISVILLE(dot)STORTEK(dot)COM> |
---|---|
To: | "'tony(at)animaproductions(dot)com'" <tony(at)animaproductions(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | RE: COPY again... |
Date: | 2001-03-12 21:08:35 |
Message-ID: | 10FE17AD5F7ED31188CE002048406DE8514CF5@lsv-msg06.stortek.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)animaproductions(dot)com]
> Sent: Wednesday, March 07, 2001 7:34 AM
> To: pgsql-general(at)postgresql(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | newsreader | 2001-03-12 21:52:03 | -F option again |
Previous Message | Tom Lane | 2001-03-12 21:06:38 | Re: Re: Data types? |