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.

Thanks,

John DeSoi, Ph.D.


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

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)