[HACKERS] Is there a psql function equivalent to a session log

[lsunley]

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

-- 
---
[EMAIL PROTECTED]
---


---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faqs/FAQ.html

Re: [HACKERS] Is there a psql function equivalent to a session log

[Bruno Wolff III]

On Sat, Jan 01, 2005 at 12:09:05 -0500,
  [EMAIL PROTECTED] 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.

---(end of broadcast)---
TIP 6: Have you searched our list archives?

   http://archives.postgresql.org