Re: multiline CSV fields

Поиск
Список
Период
Сортировка
От David Fetter
Тема Re: multiline CSV fields
Дата
Msg-id 20041111222638.GC16397@fetter.org
обсуждение исходный текст
Ответ на Re: multiline CSV fields  (Greg Stark <gsstark@mit.edu>)
Список pgsql-hackers
On Thu, Nov 11, 2004 at 03:38:16PM -0500, Greg Stark wrote:
> 
> Tom Lane <tgl@sss.pgh.pa.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 :)

http://pgfoundry.org/projects/dbi-link/

Bug reports welcome.

Cheers,
D
-- 
David Fetter david@fetter.org http://fetter.org/
phone: +1 510 893 6100   mobile: +1 415 235 3778

Remember to vote!


В списке pgsql-hackers по дате отправления:

Предыдущее
От: John Hansen
Дата:
Сообщение: Re: ltree PostgreSQL Module
Следующее
От: Greg Stark
Дата:
Сообщение: Re: MAX/MIN optimization via rewrite (plus query rewrites generally)