Re: Exporting postgres query to CSV

From: Nis Jorgensen <nis(at)superlativ(dot)dk>
To: SCassidy(at)overlandstorage(dot)com
Cc: Ryan Suarez <ryan(dot)suarez(at)sheridanc(dot)on(dot)ca>, pgsql-general(at)postgresql(dot)org
Subject: Re: Exporting postgres query to CSV
Date: 2006-05-10 11:13:53
Message-ID: 4461CAF1.4020602@superlativ.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

SCassidy(at)overlandstorage(dot)com wrote:
> A word of advice: if there is any chance that a column (e.g. text) contains
> an embedded newline, you will be much better off outputting the data in
> simple xml, instead of CSV. This works very well with Excel for import. I
> just did a simple program for this recently.

If the csv generator correctly quotes values containing quotes, commas
and newlines, Excel is going to be happy with the csv file as well

/Nis

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sim Zacks 2006-05-10 11:34:20 understanding explain data
Previous Message Houssais Hugues 2006-05-10 09:55:49 Concatenate WAL contents