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

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: lsunley(at)mb(dot)sympatico(dot)ca
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Is there a psql function equivalent to a session log
Date: 2005-01-01 19:34:51
Message-ID: 20050101193451.GB31364@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sat, Jan 01, 2005 at 12:09:05 -0500,
lsunley(at)mb(dot)sympatico(dot)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.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2005-01-01 21:14:01 Re: [HACKERS] Bgwriter behavior
Previous Message Tom Lane 2005-01-01 19:10:53 Re: exception handling in plpgsql