Re: COPY to
| От | Angshu Kar |
|---|---|
| Тема | Re: COPY to |
| Дата | |
| Msg-id | df8328740601071407o4a597a5fof41b7c5630a4da74@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: COPY to ("A. Kretschmer" <andreas.kretschmer@schollglas.com>) |
| Ответы |
Re: COPY to
Re: COPY to |
| Список | pgsql-general |
Thanks Andreas. But how can I run this from the pgAdmin III Query tool in a WinXP m/c?
--
Ignore the impossible but honor it ...
The only enviable second position is success, since failure always comes first...
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...
В списке pgsql-general по дате отправления: