Export query result to text file?

From: "Patrick Hatcher" <PHatcher(at)macys(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Export query result to text file?
Date: 2002-03-27 22:40:27
Message-ID: OF5CD0CF5C.7A0CB10B-ON88256B89.007BBD0F@fds.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Dave Dartnall 2002-03-28 02:54:54 Formatted printing output
Previous Message Rob 2002-03-27 18:09:16 Synchronizing databases