Re: Exporting postgres query to CSV

Поиск
Список
Период
Сортировка
От Nis Jorgensen
Тема Re: Exporting postgres query to CSV
Дата
Msg-id 4461CAF1.4020602@superlativ.dk
обсуждение исходный текст
Ответ на Re: Exporting postgres query to CSV  (SCassidy@overlandstorage.com)
Список 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 по дате отправления:

Предыдущее
От: Sim Zacks
Дата:
Сообщение: understanding explain data
Следующее
От: John DeSoi
Дата:
Сообщение: Re: default client_encoding with psql on windows