Postgres tables to CSV

The Postgres \copy command allows you to export tables to standard output or CSV files.