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