User and Timestamps

Hi NG,

working with postgres is very intresting...for a newby like me a big
big playground and so I found a nother toy which i like to handle :)

Rules or Triggers + Functions

In all of the maintable in my DB I have the following Fields:

created      timestamptz
createdby    vchar(15)
modified     timestamptz
modifiedby   vchar(15)

Now I like to setup a mechanismus which tke care of inserts and
updates. Everytime an insert is calld created shuld stamped whith the
current loggedin user and createdby whith Current_Timestamp....Same
for update whith modifed and modifedby.

I tried to set up a rule but it wont work because I find no way to
identify the newly inserted row :(

Thankyou for your support

Simon