Export a query from postgres as CSV

csvexport.sh

#! /usr/bin/env bash

# export a query as a csv
# $1 DB name
# $2 query ex: "SELECT * from tablename"
# $3 output file, ex: output.csv
#
# ./csvexport.sh users "SELECT * from users" users.csv
#
psql -d $1 -P format=unaligned -P tuples_only -P fieldsep=\, -c "$2" > $3