Re: Export query result to text file?

It works.... fine but creates a file "test.txt;" and not "test.txt"

If you do not give semicolon at the end, then it waits for it and if you
give it, it adds that in filename.

HTH

Denis



----- Original Message -----
From: "Patrick Hatcher" <PHatcher@macys.com>
To: <pgsql-novice@postgresql.org>
Sent: Thursday, March 28, 2002 4:10 AM
Subject: [NOVICE] Export query result to text file?


> Howdy,
> I'm trying to use a query to export some data.  My file is created, but no
> data is available.  If I run the query without exporting, it works fine.
> Select * from table1 limit 100 \o /home/phatcher/test.txt;
>
> must I always route the file first and then do my query?
> Thanks
>
> Patrick Hatcher
> Macys.Com
> Legacy Integration Developer
> 415-932-0610 office
> HatcherPT - AIM
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org