Re: CSV mode option for pg_dump - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: CSV mode option for pg_dump
Date
Msg-id 448DAB0D.3000903@dunslane.net
Whole thread Raw
In response to Re: CSV mode option for pg_dump  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: CSV mode option for pg_dump  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Extended SERIAL parsing
Next
From: Josh Berkus
Date:
Subject: Re: CSV mode option for pg_dump