Re:

From: Frank Bax <fbax(at)sympatico(dot)ca>
To: "M(dot)L(dot)Bowman" <M(dot)L(dot)Bowman(at)ukc(dot)ac(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re:
Date: 2002-01-17 19:36:36
Message-ID: 3.0.6.32.20020117143636.01a63ab0@pop6.sympatico.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

At 06:59 PM 1/17/02 +0000, M.L.Bowman wrote:
> In Ingres I can check if the ingres superuser is the current userby using
> WHERE dbmsinfo('username') = dbmsinfo('dba')
> I can't find out how to do the equivalent in postgres. Can anyone help?

fbax=# select usename,usesuper from pg_user where usename = current_user;
usename | usesuper
---------+----------
fbax | t
(1 row)

In response to

  • at 2002-01-17 18:59:18 from M.L.Bowman

Browse pgsql-general by date

  From Date Subject
Next Message Holger Krug 2002-01-17 19:37:47 Re:
Previous Message Emmanuel SARACCO 2002-01-17 19:06:02 Re: installing pl/pgsql