On Tue, Oct 20, 2009 at 07:08:08AM -0000, dbi-users-digest-h...@perl.org wrote: > Subject: Does Pg's psql have an equivalent to Oracle's spool cmd? > From: Ron Savage <r...@savage.net.au> > To: List DBI <dbi-users@perl.org> > > Hi Folks > > If it does, I can't see it in the Ref Man # 1. > > Any ideas? > Mmmm I don't know Oracle at all but Query Buffer \e [FILE] edit the query buffer (or file) with external editor \ef [FUNCNAME] edit function definition with external editor \p show the contents of the query buffer \r reset (clear) the query buffer \s [FILE] display history or save it to file \w FILE write query buffer to file Input/Output \copy ... perform SQL COPY with data stream to the client host \echo [STRING] write string to standard output \i FILE execute commands from file \o [FILE] send all query results to file or |pipe \qecho [STRING] write string to query output stream (see \o)
might be of interest? I used the \? command to list the above - amongst other things. Regards L.