Re: Writing Result to Disk (psql)

Yes it is. Check out the \o option. For example:

processdata=> \o foobar
processdata=> select * from maintent;

Will put the output from the query "select * from
maintent" into the file foobar. You might also find
the \f and \t options to be useful. Try typing in \?
at the psql prompt for more information.

--- ryan(at)paymentalliance(dot)net wrote:
> Is it possible to write the result of a SELECT
> statement to disk from
> psql?
>
> Thanks!
>
> -r
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to
majordomo(at)postgresql(dot)org

__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/