Re: execute function after user connect

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: John DeSoi <jd(at)icx(dot)net>
Cc: pgsql List <pgsql-general(at)postgresql(dot)org>
Subject: Re: execute function after user connect
Date: 2004-04-02 19:26:01
Message-ID: 20040402192601.GA17213@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Apr 02, 2004 at 11:58:42 -0500,
John DeSoi <jd(at)icx(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2004-04-02 19:30:36 Re: Storage cost of a null column
Previous Message Joe Sunday 2004-04-02 19:17:42 Re: ERROR: column 'xxx' does not exist (under v. 7.4.1)