Jacob,

[..]

> ie supposed i have a tigger on before insert for a table and i want to
> log each inser to this table with the username inserting, how would i go
> about finding the current username?

Look at Current_X variables for finding the context in which your trigger is
executing.

The one you're after is CURRENT_USER.
.. but CURRENT_ROLE, CURRENT_TRANSACTION, CURRENT_CONNECTION might interest
you as well.

--
Jerome