Postgres Pro
Downloads
Home   >   mailing lists

Is there an opposite to pg_get_userbyid() ? - Mailing list pgsql-general

From Andreas
Subject Is there an opposite to pg_get_userbyid() ?
Date
Msg-id 416EBA7E.7000409@gmx.net
Whole thread Raw
Responses Re: Is there an opposite to pg_get_userbyid() ?  (Michael Fuhr <mike@fuhr.org>)
List pgsql-general
Tree view 
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 ?

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Need some advice on appropriate PL strategy... ["solved/thanks"]
Next
From: Richard Huxton
Date:
Subject: Re: creating audit tables