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@paymentalliance.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@postgresql.org


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