Re: saving a query and reults to a file.

On Tue, 2005-11-29 at 20:47 +0100, A. Kretschmer wrote:
> am 29.11.2005, um 18:38:50 +0000 mailte Oliver Elphick folgendes:
> > On Tue, 2005-11-29 at 11:35 -0500, T. Lackey wrote:
> > > Is there an easy way to save a series of queries and query results to
> > > a single file like /tee in MySQL? I am running version 8.-beta4 on
> > > windows XP.
> >
> > In psql:
> >
> > \o output_file_name
> > ...various queries...
> > \o
>
> This isn't the right answer. \o redirect _only_ query results to the
> file, not the queries.
>
> And yes, i don't know the answer.

Of course, you are right. I tried psql -e and -a and -L and none of
them do it. The only way to get the queries into the output file as
well is to copy them there separately:

\o output_file_name
\qecho SELECT * FROM my_table;
SELECT * FROM my_table;
\o

It's a bit cumbersome.

The other way is to capture the whole session output. In Linux you can
do that with the script command, but I don't know if Windows has any
decent tools like that.

--
Oliver Elphick olly(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/A54310EA 92C8 39E7 280E 3631 3F0E 1EC0 5664 7A2F A543 10EA
========================================
Do you want to know God? http://www.lfix.co.uk/knowing_god.html