We are supporting Win32 in 7.4, so it is very likely COPY will support
carriage returns the next release.
---
Tom Lane wrote:
> Oliver Vecernik <[EMAIL PROTECTED]> writes:
> > It's always the same problem with CR/LF conversi
Oliver Vecernik <[EMAIL PROTECTED]> writes:
> It's always the same problem with CR/LF conversions ...
Ah, you figured it out. (Didn't see your followup right away because of
the changed subject line.)
> After changing it to just LFs, everthing worked like a charm. Is there
> an elegant way to h
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, Oliver Vecernik wrote:
> Oliver Vecernik schrieb:
>
> > Hi all!
> >
> > I'm trying to import a text file from Suunto Dive Manager. I've got
> > following table structure:
>
> Arghh ...
>
> It's always the same problem with CR/LF conversions ...
>
> After changing it to just LF
Oliver Vecernik schrieb:
Hi all!
I'm trying to import a text file from Suunto Dive Manager. I've got
following table structure:
Arghh ...
It's always the same problem with CR/LF conversions ...
After changing it to just LFs, everthing worked like a charm. Is there
an elegant way to handle
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
Hi all!
I'm trying to import a text file from Suunto Dive Manager. I've got
following table structure:
CREATE TABLE dives (
id int,
dive_number int,
dive_date date,
time_of_day time,
series int,
dc_dive_number int,
dive_time int,
surface_interval int,
max_depth float,
mean_depth float,
dc_type i
