Hi, I'd like to store who changed records on some tables. I'd prefer not to store the username but rather his/her ID. Will I allways have to run select usesysid from pg_user where usename=session_user; or is there a complement to pg_get_userbyid() ?
Can I have this as a default-value for a created_by integer-collumn ?
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match