Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Dump and Query
- From: Bricklen Anderson <banderson(at)presinet(dot)com>
- To: "Andy Shellam (Mailing Lists)" <andy(dot)shellam-lists(at)mailnetwork(dot)co(dot)uk>
- Cc: pgsql-admin(at)postgresql(dot)org
- Subject: Re: Dump and Query
- Date: Wed, 27 Dec 2006 08:17:12 -0800
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
- References:
- Dump and Query
- From: Enrico
- Re: Dump and Query
- From: Andy Shellam (Mailing Lists)
- Dump and Query
- Prev by Date: Re: Dump and Query
- Next by Date: Re: psql does not save contents into file at end of command.
- Previous by thread: Re: Dump and Query
- Next by thread: Re: Dump and Query
- Indexes: