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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match