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@lfix.co.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