Thanks Andreas. But how can I run this from the pgAdmin III Query tool in a WinXP m/c?
On 1/7/06, A. Kretschmer < andreas.kretschmer@schollglas.com> wrote:am 07.01.2006, um 14:13:28 -0600 mailte Angshu Kar folgendes:
> Hi Pgsql,
>
> I want to copy the output of a SELECT query onto a text file. I'm trying to
> use the COPY command for that as :
>
> COPY (SELECT .... ) to 'outfile'
Wrong.
\o output.txt
select ...
\o
And now you have the result in 'output.txt'.
HTH, Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47212, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
--
Ignore the impossible but honor it ...
The only enviable second position is success, since failure always comes first...