Re: COPY to

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(dot)kretschmer(at)schollglas(dot)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...