CREATE USER username WITH SUPERUSER PASSWORD 'passwordstring';

Enviar consulta por linea de comandos

psql -d DatabaseName -U UserName -c "SELECT * FROM TABLE" -o /root/Desktop/file.txt

tambien dentro de psql

\copy (SELECT * FROM res_partner) TO '/home/ivancandelas/partner.csv' csv header;