Oliver Vecernik <[EMAIL PROTECTED]> writes:
> My import gives following error:
> sport=# copy dives from '/var/n/tmp/ov.CSV' delimiters ',';
> ": can't parse "ne 1, pg_atoi: error in "0
The weird formatting of the error message suggests that the problem
is DOS-style newlines (CR/LF). COPY only l
On Tue, 28 Jan 2003, Achilleus Mantzios wrote:
> On Tue, 28 Jan 2003, Oliver Vecernik wrote:
>
> >
> > 1,1,"07.08.2001","11:35",1,1,2220,0,6.0,0.0,12,0,"",20,0,0,0,1,"Sarigerme","Asche
> > Bucht","wolkenlos",">20m",35,0,30,"","Mehmet
> > Semerkant","","",0.0,1,0.,0.,0,0.,0,"","",""
On Tue, 28 Jan 2003, Oliver Vecernik wrote:
>
> 1,1,"07.08.2001","11:35",1,1,2220,0,6.0,0.0,12,0,"",20,0,0,0,1,"Sarigerme","Asche
> Bucht","wolkenlos",">20m",35,0,30,"","Mehmet
> Semerkant","","",0.0,1,0.,0.,0,0.,0,"","","","","",12,0,0,0
Why dont you get rid of "'s ?
e.g.
1,1
