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/