Skip site navigation (1) Skip section navigation (2)

Re: saving a query and reults to a file.

From: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
To: "T(dot) Lackey" <lackey(at)ltu(dot)edu>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: saving a query and reults to a file.
Date: 2005-11-29 18:38:50
Message-ID: 1133289530.10517.88.camel@linda.lfix.co.uk (view raw or flat)
Thread:
Lists: pgsql-novice
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

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


In response to

Responses

pgsql-novice by date

Next:From: A. KretschmerDate: 2005-11-29 19:47:08
Subject: Re: saving a query and reults to a file.
Previous:From: operationsengineer1Date: 2005-11-29 18:19:06
Subject: Re: postgres database file location

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group