Re: Listing users

From: "Anthony E (dot) Greene" <agreene(at)pobox(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Listing users
Date: 2001-01-07 01:57:27
Message-ID: 20010106205727.E3399@cp5340
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, 04 Jan 2001 19:10:42 "Merhaut, James H" wrote:
>I see that there is a deleteuser and createuser scripts.
>Is there a script that lists the users created?

select * from pg_user;

--
Anthony E. Greene <agreene(at)pobox(dot)com> <http://www.pobox.com/~agreene/>
PGP Key: 0x6C94239D/7B3D BD7D 7D91 1B44 BA26 C484 A42A 60DD 6C94 239D
Chat: AOL/Yahoo: TonyG05 ICQ: 91183266
Linux. The choice of a GNU Generation. <http://www.linux.org/>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Anthony E . Greene 2001-01-07 02:01:37 Re: Granting Permissions to User To Access Database
Previous Message Tom Lane 2001-01-06 21:48:10 Re: install on Solaris