when you forget to properly format the results of a query that takes forever
psql=> select some, stuff, and, things
psql-> from some_great_table sgt
psql-> join other_awesome_table oat on sgt.id = oat.foreign_id
psql-> where oat.some_stuff is true
some | stuff | and | things
-----+-------+-----+-------
1 | 1 | 2 | 3
5 | 8 | 13 | 21
34 | 55 | 89 | 144
(3 rows)
Shit. I totally forgot to format this or write it into a file.
Whelp, this format sucks, and that took like 2 hours to run! I can't copy and paste it into a spreadsheet or anything.
psql_to_csv to the rescue. Just copy that shit.
$ pbpaste | psql_to_csv | pbcopy
And now, in your clipboard, you've got:
some stuff and things
1 1 2 3
5 8 13 21
34 55 89 144
Or write it to files.
psql_to_csv -i psql_output.txt -o somestuffandthings.csv
Want a comma delimiter instead of tabs, no problem dude!
psql_to_csv -i psql_output.txt -o somestuffandthings.csv -d ','
pip install psql_to_csv
