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