Re: Redirecting query's output to a textfile?

for a single command, \g.  Example

select * from employees \g '/home/dbadmin/employees.tab'

Note that there isn't a semicolon at the end.  '\g' takes
care of that.  '\g' will also let you pipe the table output
to other commands........

Thalis A. Kalfigopoulos wrote:
> Depends on how you place the query? I assume you are asking about the psql client, so before the query just do:
> \o output.txt
>


--
P. J. "Josh" Rovero                                 Sonalysts, Inc.
Email: rovero@sonalysts.com    www.sonalysts.com    215 Parkway North
Work: (860)326-3671 or 442-4355                     Waterford CT 06385
***********************************************************************