psql2csv - Export PostgreSQL Tables to CSV


What?

psql2csv dumps PostgreSQL tables into comma-separated values (.CSV) files, compatible with almost all spreadsheet and mail merge programs:


Why?

Parents Centre needed to do this to export into another database.

They also needed to have a (power) user have control over what fields go where, so the utility is vastly configurable in this manner. Way more than would normally be needed, but that's fine: it doesn't slow you down and you don't have to use that stuff!


How?

psql2csv is written in C for performance reasons. Field names and values can be translated through a table on the database if desired.


Where?

Download psql2csv from here


Who?

Written by Andrew McMillan

 


Andrew's Linux Page  |   © Andrew McMillan, 1999-2000 released under the Artistic License