execute function after user connect

[John DeSoi]

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

[Bruno Wolff III]

On Fri, Apr 02, 2004 at 11:58:42 -0500,
John DeSoi <[e-mail]> 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.

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)