Re: saving a query and reults to a file.

PGAdmin3 gives the user the option to run a query and
output it to a file.  It is a "play" style triangle
with a floppy disk icon - 4the from the right on the
latest version of pgadmin3.

not sure if this helps or not.

--- Oliver Elphick <olly@lfix.co.uk> wrote:

> 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
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>                http://archives.postgresql.org
>





__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com