Postgres Pro
Downloads
Home   >   mailing lists

Thread: Sending query to a file

Sending query to a file

From
Francisco Reyes
Date:
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
do a query and when done I then do '\g <filename>'. It works, but for a
lengthy query it can take very long having to do the query twice.

Re: Sending query to a file

From
"Brett W. McCoy"
Date:
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
> do a query and when done I then do '\g <filename>'. It works, but for a
> lengthy query it can take very long having to do the query twice.

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

-- Brett
                                          http://www.chapelperilous.net/
------------------------------------------------------------------------
Courage is your greatest present need.

Re: Sending query to a file

From
Francisco Reyes
Date:
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.

Re: Sending query to a file

From
"Brett W. McCoy"
Date:
On Sat, 10 Nov 2001, Francisco Reyes wrote:

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

Why do you need to use \g?  Just terminate your query with a semi-colon
and press enter.  They do the same thing.  If you want to save the result
of a query, start your session with \o [file], and use \o without any
options to make query results go back to stdout.  Or use \g [file] in one
shot.  These are more or less the same:

\o result.txt
SELECT * FROM sometable WHERE id > 12;
\o

SELECT * FROM sometable WHERE id > 12
\g result.txt

-- Brett
                                          http://www.chapelperilous.net/
------------------------------------------------------------------------
You can always pick up your needle and move to another groove.
        -- Tim Leary