Skip site navigation (1) Skip section navigation (2)

Re: multiline CSV fields

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Andrew Dunstan <andrew(at)dunslane(dot)net>,Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: multiline CSV fields
Date: 2004-11-29 13:41:26
Message-ID: 200411291341.iATDfQk04439@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Bruce Momjian wrote:
> Andrew Dunstan wrote:
> > >OK, then should we disallow dumping out data in CVS format that we can't
> > >load?  Seems like the least we should do for 8.0.
> > >
> > >  
> > >
> > 
> > As Tom rightly points out, having data make the round trip was not the 
> > goal of the exercise. Excel, for example, has no trouble reading such 
> > data (or at least my installation of it).
> > 
> > Personally I consider CSVs with line end chars embedded in fields to be 
> > broken anyway, but this was something that was specifically mentioned 
> > when we were discussing requirements, which is why I coded for it.
> 
> OK, I am pretty uncomforable with this but you know this usage better
> than I do.  Should we issue a warning message stating it will not be
> able to be reloaded?

Also, can you explain why we can't read across a newline to the next
quote?  Is it a problem with the way our code is structured or is it a
logical problem?  Someone mentioned multibyte encodings but I don't
understand how that applies here.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

Responses

pgsql-hackers by date

Next:From: Richard WeltyDate: 2004-11-29 13:41:36
Subject: Re: [HACKERS] Adding Reply-To: <listname> to Lists configuration ...
Previous:From: Bruce MomjianDate: 2004-11-29 13:34:27
Subject: Re: multiline CSV fields

pgsql-patches by date

Next:From: Andrew DunstanDate: 2004-11-29 14:00:28
Subject: Re: multiline CSV fields
Previous:From: Bruce MomjianDate: 2004-11-29 13:34:27
Subject: Re: multiline CSV fields

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group