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?