Re: multiline CSV fields

From: David Fetter <david(at)fetter(dot)org>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: multiline CSV fields
Date: 2004-11-11 22:26:38
Views: Raw Message | Whole Thread | Download mbox
Lists: pgsql-hackerspgsql-patches

On Thu, Nov 11, 2004 at 03:38:16PM -0500, Greg Stark wrote:
> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
> > I would vote in favor of removing the current code that attempts
> > to support unquoted newlines, and waiting to see if there are
> > complaints.
> Uhm. *raises hand*
> I agree with your argument but one way or another I have to load
> these CSVs I'm given. And like it or not virtually all the CSVs
> people get are going to be coming from Excel. So far with 7.4 I've
> just opened them up in Emacs and removed the newlines, but it's a
> royal pain in the arse.

Meanwhile, check out dbi-link. It lets you query against DBI data
sources including DBD::Excel :)

Bug reports welcome.

David Fetter david(at)fetter(dot)org
phone: +1 510 893 6100 mobile: +1 415 235 3778

Remember to vote!

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Stark 2004-11-11 22:34:43 Re: MAX/MIN optimization via rewrite (plus query rewrites generally)
Previous Message John Hansen 2004-11-11 21:15:35 Re: ltree PostgreSQL Module

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2004-11-11 22:39:16 Re: Proposed patch to remove USERLIMIT
Previous Message Magnus Hagander 2004-11-11 21:07:53 win32 ps info