Redirecting query's output to a textfile?

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

you can see several options/switches by giving \?

regards,
thalis

On Fri, 15 Feb 2002, Peter Peltonen wrote:

On Fri, Feb 15, 2002 at 06:11:08PM +0200,
Peter Peltonen <peter.peltonen@fivetec.com> wrote:

A basic question:

How in PostgreSQL do I redirect the output of an SQL query to a textfile?

Assuming you are talking about doing this in psql, the answer is to use:
\o filename
\? will provide help on the other psql \ commands.

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
***********************************************************************

If you use psql and your query is in a file, try this:

$psql <dbname>

<dbname># \o <filename> (puts the output of the next query in a file)

<dbname># \i <queryfile> (reads and executes the query from the file)

<dbname> \q (quit psql)

Peter Peltonen wrote:

A basic question:

How in PostgreSQL do I redirect the output of an SQL query to a textfile?

Hope this helps...
_________________________
Herb Blacker
Database Administrator
ReCare, Inc.
(512) 791-4340
herbblacker@isgenesis.com