Postgres Pro
Downloads
Home   >   mailing lists

Export query result to text file? - Mailing list pgsql-novice

From Patrick Hatcher
Subject Export query result to text file?
Date
Msg-id OF5CD0CF5C.7A0CB10B-ON88256B89.007BBD0F@fds.com
Whole thread Raw
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: Synchronizing databases
Next
From: denis@coralindia.com
Date:
Subject: Re: Export query result to text file?