Postgres Pro
Downloads
Home   >   mailing lists

Re: how do i import my sql query result to a file - Mailing list pgsql-sql

From Ludwig Lim
Subject Re: how do i import my sql query result to a file
Date
Msg-id 20020719003442.36140.qmail@web40009.mail.yahoo.com
Whole thread Raw
In response to how do i import my sql query result to a file  (Joseph Syjuco <joseph@asti.dost.gov.ph>)
Responses Re: how do i import my sql query result to a file
List pgsql-sql
Tree view 
--- Joseph Syjuco <joseph@asti.dost.gov.ph> wrote:
> how do i import results of my select query to a file
> thanks
> 

in the psql command prompt type
\o <filename>

and then type your select query.
The result will be dumped into <filename>

ludwig.

__________________________________________________
Do You Yahoo!?
Yahoo! Autos - Get free new car price quotes
http://autos.yahoo.com

pgsql-sql by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Indexing UNIONs
Next
From: Joseph Syjuco
Date:
Subject: Re: how do i import my sql query result to a file