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;