On Fri, Apr 02, 2004 at 11:58:42 -0500,
John DeSoi <jd@icx.net> wrote:[color=blue]
> 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.[/color]
You can set the schema path based on the user or the database (but not
both at once), using ALTER USER or ALTER DATABASE.
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to
majordomo@postgresql.org)
