Re: Keeping track of updates/performances

Romain Billon-Grand <billongrand(at)hotmail(dot)fr> wrote:

> Hello!
>
> Please give me your advices about the best way to keep in each table those
> informations:
> name of the user who created a row
> name of the last user who modified it
> timestamp for creation
> timestamp for last modification
>
> 1/ I have been looking for built in options in postgres but I guess I have to
> build it myself...?
> Of course if Postgres already does it I am very happy, and all of the following
> quetsions are useless but I did not find this in the documentation...
>
> 2/ Is there some SQL query to return the "usermane" from pg_catalog or
> something

You can use TRIGGER for Insert/Update, the current user can you detect
with current_user.

Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°