Writing Result to Disk (psql)

Is it possible to write the result of a SELECT statement to disk from
psql?

\o <filename>
<SELECT STATEMENT>
\o

Make sure you provide a complete path to the <filename> so you can find it
later! :-)

len morgan

ryan@paymentalliance.net writes:

Is it possible to write the result of a SELECT statement to disk from
psql?

\o filename
select things;
\o (reset to terminal)

--
Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter

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/

in psql i use:
\o filename
to send all output to a file, then run the select statement, then just
\o
to stop sending output to the file.
is that what you meant?
tamsin

Hi all,

Out of interest, you can output directly to attached printers, serial
ports, etc using the same format :

\o /dev/lp0

\o /dev/ttyS0

\o /dev/hdd4 <-- Don't do this one!

etc

Makes it interesting, especially in combination with outputting binary
data, etc. Have to be careful to set your alignment correctly though,
else certain things won't work.

:-)

Regards and best wishes,

Justin Clift