Re: Exporting postgres query to CSV - Mailing list pgsql-general

From Nis Jorgensen
Subject Re: Exporting postgres query to CSV
Date
Msg-id 4461CAF1.4020602@superlativ.dk
Whole thread Raw
In response to Re: Exporting postgres query to CSV  (SCassidy@overlandstorage.com)
List pgsql-general
SCassidy@overlandstorage.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


pgsql-general by date:

Previous
From: Sim Zacks
Date:
Subject: understanding explain data
Next
From: John DeSoi
Date:
Subject: Re: default client_encoding with psql on windows