Export result to CSV format

Open Ryo51289 opened this issue 5 years ago • 3 comments

Hi darold, Thank for your very useful tools, it's save so much time! I have some table need export to CSV file, I read in document and see a flag : --dump_as_csv but seem it's relate to report, not data export. Are there any way to achive the csv file?

Oct 26 '20 08:10 Ryo51289

Yes --dump_as_csv is used for assessment reports and there is no CSV output for data. You can easily use the COPY output to convert it as CSV through a scripts, the separator is tabulation.

Oct 26 '20 08:10 darold

@darold Thank you, I will try to custome the COPY output. But it's greate if this feature available in next releases!

Oct 26 '20 08:10 Ryo51289

@Ryo51289 the pg_bulkload SKIP option lets you bypass the those pesky lines.

Feb 17 '21 20:02 RonJohn2