Re: - Mailing list pgsql-general

From Frank Bax
Subject Re:
Date
Msg-id 3.0.6.32.20020117143636.01a63ab0@pop6.sympatico.ca
Whole thread Raw
In response to  ("M.L.Bowman" <M.L.Bowman@ukc.ac.uk>)
List 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)



pgsql-general by date:

Previous
From: Holger Krug
Date:
Subject: Re:
Next
From: Neil Conway
Date:
Subject: Re: Is It Too Big ? - Customer Data Warehouse Growth