Re: function to return pg_user.usesysid

From: Neil Conway <neilc(at)samurai(dot)com>
To: "Dr(dot) Ernst Molitor" <molitor(at)uni-bonn(dot)de>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: function to return pg_user.usesysid
Date: 2003-02-07 23:50:25
Message-ID: 1044653454.694.1.camel@tokyo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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 = CURRENT_USER;

Cheers,

Neil
--
Neil Conway <neilc(at)samurai(dot)com> || PGP Key ID: DB3C29FC

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Brown 2003-02-08 11:09:34 Re: function to return pg_user.usesysid
Previous Message greg 2003-02-07 20:06:00 Re: PGP signing releases