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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-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
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Welty | 2004-11-29 13:41:36 | Re: [HACKERS] Adding Reply-To: <listname> to Lists configuration ... |
Previous Message | Bruce Momjian | 2004-11-29 13:34:27 | Re: multiline CSV fields |
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2004-11-29 14:00:28 | Re: multiline CSV fields |
Previous Message | Bruce Momjian | 2004-11-29 13:34:27 | Re: multiline CSV fields |