The quickest way from Postgres to a spreadsheet

Need to quickly get some data out of Postgres and into Excel/Numbers/Google Docs/etc?

copy (select foo, bar from baz) to stdout with csv;

From within any psql prompt (including the heroku one) and then you can just copy/paste into your spreadsheet program of choice.

For google docs I've found it works better to paste it into a CSV file and then upload it rather than dicking around with copy and paste.