Forum OpenACS Development: OT: postgres trigger to set row owner on insert

I have created a trigger in oracle that sets the owner (user_id) of a row when it is inserted. The trigger retrieves the user_id from the application context so the SQL statement does not contain the user_id.

Does postgres have a similar concept to application context (session context) as oracle?