Thread: Is there a psql function equivalent to a session log

One of my testers asked me if there is a function in psql that is
equivalent to a session log - something that will write out commands sent
to the server and the results written to a file while still displaying the
results on screen.

I can't find anything like this, but I think I can put it together quite
quickly. Has anyone else done something like this?

Lorne

-- 
-----------------------------------------------------------
lsunley@mb.sympatico.ca
-----------------------------------------------------------

On Sat, Jan 01, 2005 at 12:09:05 -0500, lsunley@mb.sympatico.ca wrote:
> One of my testers asked me if there is a function in psql that is
> equivalent to a session log - something that will write out commands sent
> to the server and the results written to a file while still displaying the
> results on screen.
> 
> I can't find anything like this, but I think I can put it together quite
> quickly. Has anyone else done something like this?

You can kind of do it with tee (/o output can be sent to programs), but tee
doesn't flush output so you would probably need to modify it to flush on
newlines or something if you really wanted to use it for an interactive
session.