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