Re: CSV mode option for pg_dump

Joshua D. Drake wrote:
> Andrew Dunstan wrote:
>>
>> Something someone said on IRC just now triggered a little memory ...
>> I think we should provide an option to have pg_dump work in CSV mode
>> rather than text mode. This probably doesn't have much importance in
>> the case of text dumps, but in custom or tar dumps where you might
>> want to get at individual data members, having an option for CSVs
>> that you want to load into some other product might be nice.
>>
>> This should be a pretty low cost item, I expect (good newbie project?)
>
> Uhh... just about any application that can import CSV can import our
> dumps. It just tell it the delimiter is a tab.
>

No it won't, not if there are tabs in the data.

Why do you think we did CSV in the first place? Precisely because our
dump does *not* work as a general export mechanism for arbitrary data.

cheers

andrew