Add Current User in DB Field

[KYons]

Hallo ,

i try to add the current User every time he inserts an new row in the Table. Can some body help ..

Thanx

 

[ceco]

there are some functions here, you may choose from

http://www.postgresql.org/docs/8.1/interactive/functions-info.html

basicly if you talk for PostgreSQL user (not some kind of your accounting) you can do it like that

create table example (id integer, some_field text, added_by text not null default current_user);

if you are talking for your account there is a way, but first tell which is your case

 

[KYons]

Thanx Ceco ..
it works with "current_user" in the field for standard value