Re: Can I use Postgres rules to reset session variables before/after queries? - Mailing list pgsql-general

> On Jan 24, 2021, at 21:00, Andrew Stuart <andrew@salesgrid.com.au> wrote:
> Can anyone suggest if session variables can be SET/RESET using Postgres rules, or optionally perhaps there is a
betterway to do so? 

PostgreSQL poolers generally use the RESET ALL command when reassigning a session to clear the session state:

    https://www.postgresql.org/docs/current/sql-reset.html

You probably want to do this rather than try to intercept every single operation in order to the reset at the end.

--
-- Christophe Pettus
   xof@thebuild.com