Postgres Pro
Downloads
Home   >   mailing lists

Re: Detailed logging, but only for one user? - Mailing list pgsql-general

From Richard Huxton
Subject Re: Detailed logging, but only for one user?
Date
Msg-id 470FC229.2060505@archonet.com
Whole thread Raw
In response to Detailed logging, but only for one user?  ("Michael Nolan" <htfoot@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: Need advice on keeping backup database up to date
Next
From: Richard Huxton
Date:
Subject: Re: Need advice on keeping backup database up to date