Re: Detailed logging, but only for one user?

From: Richard Huxton <dev(at)archonet(dot)com>
To: Michael Nolan <htfoot(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Detailed logging, but only for one user?
Date: 2007-10-12 18:51:21
Message-ID: 470FC229.2060505@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Michael Nolan wrote:
> Is there any way to enable detailed logging (ie, at the SQL statement level)
> but only for one user?

ALTER ROLE SET <config-param> = <value>;
ALTER USER SET <config-param> = <value>;

--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2007-10-12 18:51:49 Re: Need advice on keeping backup database up to date
Previous Message Richard Huxton 2007-10-12 18:50:13 Re: Out of memory with ODBC