Is there an opposite to pg_get_userbyid() ?

From: Andreas <maps(dot)on(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Is there an opposite to pg_get_userbyid() ?
Date: 2004-10-14 17:42:22
Message-ID: 416EBA7E.7000409@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 ?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2004-10-14 18:07:23 Re: creating audit tables
Previous Message Michael Fuhr 2004-10-14 17:20:33 Re: Need some advice on appropriate PL strategy... ["solved/thanks"]