Re: execute function after user connect - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: execute function after user connect
Date
Msg-id 20040402192601.GA17213@wolff.to
Whole thread Raw
In response to execute function after user connect  (John DeSoi <jd@icx.net>)
Responses Re: execute function after user connect
List pgsql-general
On Fri, Apr 02, 2004 at 11:58:42 -0500,
  John DeSoi <jd@icx.net> wrote:
> Is there a mechanism to execute a function after the user connects to
> the database? I would like to set the schema path based on the user's
> group membership. It would also be nice to log to a table on
> connect/disconnect.

You can set the schema path based on the user or the database (but not
both at once), using ALTER USER or ALTER DATABASE.

pgsql-general by date:

Previous
From: Randall Skelton
Date:
Subject: Re: Storage cost of a null column
Next
From: Bruno Wolff III
Date:
Subject: Re: row-level security model