Re: Sending query to a file - Mailing list pgsql-novice

From Francisco Reyes
Subject Re: Sending query to a file
Date
Msg-id 20011110161213.N37192-100000@zoraida.natserv.net
Whole thread Raw
In response to Re: Sending query to a file  ("Brett W. McCoy" <bmccoy@chapelperilous.net>)
Responses Re: Sending query to a file
List pgsql-novice
On Sat, 10 Nov 2001, Brett W. McCoy wrote:

> On Sat, 10 Nov 2001, Francisco Reyes wrote:
> > What is the best way to send a query to an ASCII file?
> > I have been using "\g", but that seems to require doing the query twice. I

> \o <file> will send the results of queries to a file.

Thanks. That worked.
Is there a better way to use "\g" than running it after running the query
initially?
The description says "send query to backend (and results in [file] or
|pipe)". For starters when I do "\g" it doesn't seem to go to the backend.
It processes the last query and I don't get the prompt back until it is
done.


pgsql-novice by date:

Previous
From: "Brett W. McCoy"
Date:
Subject: Re: Sending query to a file
Next
From: "Brett W. McCoy"
Date:
Subject: Re: Sending query to a file