Andy Shellam (Mailing Lists) wrote:
Hi Enrico, The following command will get you a text file of your result-set:# echo "SELECT customer_id, first_name, sur_name FROM users;"|/usr/local/pgsql/bin/psql -U [username] -d [database] > myfile.txt# cat myfile.txt
Alternative version:psql -d <your dbname> -c "SELECT customer_id, first_name, sur_name FROM users" -o myfile.txt
