Re: Help: How to store query output in a file !!!

selkovjr@mcs.anl.gov

From: selkovjr@mcs.anl.gov
To: NEERAJ BANSAL <nbansal1@email.mot.com>
Cc: pgsql-general@postgresql.org
Date: 2000-06-14T07:08:17Z
Lists: pgsql-general
> 
> Does anyone knows how do you send query output to a file???

Welcome to Unix(TM):

psql <database> -c "select * from <table name>, etc." > <file name>

See also:

http://www.isu.edu/departments/comcom/unix/workshop/io.html

or, type "unix tutorial" in any web search engine.

--Gene

> I tried following but it does not work:
> select * from <table name> \o <file name> ;
> 
> Please let me know if anyone knows!! Thanks in advance
> 
> Neeraj
> neeraj_b@hotmail.com