Hi all,
Also need add function, returned GetSessionUserId() too.
On 7 Feb 2003, Dr. Ernst Molitor wrote:
DEM>record offers saving a few bytes per record, so I wrote a _very small_
DEM>add-on to directly access the usesysid information, using the function
DEM>GetUserId().
--
Olleg Samoylov
--
Neil Conway wrote:
> On Fri, 2003-02-07 at 07:03, Dr. Ernst Molitor wrote:
> > Hm, by the way, what about adding a function like current_userid to the
> > core functionality of PostgreSQL?
>
> What exactly would this do that couldn't be done by just querying
> pg_user directly?
>
> SELECT usesysi
On Fri, 2003-02-07 at 07:03, Dr. Ernst Molitor wrote:
> Hm, by the way, what about adding a function like current_userid to the
> core functionality of PostgreSQL?
What exactly would this do that couldn't be done by just querying
pg_user directly?
SELECT usesysid FROM pg_user WHERE usename = CURR
Dear PostgreSQL developers,
as far as I know, there is no function available to directly access the
user id (pg_(shadow|user).usesysid)
of the current database user, while the user's name is easily available
(function current_user).
For a couple of databases I'm using or designing, it is neces