From: | <operationsengineer1(at)yahoo(dot)com> |
---|---|
To: | olly(at)lfix(dot)co(dot)uk, "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
Cc: | Christian Hofmann <christian(dot)hofmann(at)gmx(dot)de>, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: saving a query and reults to a file. |
Date: | 2005-11-29 23:21:26 |
Message-ID: | 20051129232126.23885.qmail@web33311.mail.mud.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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(at)lfix(dot)co(dot)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(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
>
>
> ---------------------------(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
From | Date | Subject | |
---|---|---|---|
Next Message | Srinivas Iyyer | 2005-11-29 23:44:10 | Combinatorial problem |
Previous Message | Oliver Elphick | 2005-11-29 22:48:42 | Re: saving a query and reults to a file. |