Thread: Show all users

Show all users

From
Jan Kohout
Date:
Have a nice day,

    I'm starting to PostgreSQL and during my tries I created several
users and databases. I can see databases, but I can't see the users.
And, of course, I will need to see all users in my applications.


                Thanks for answer

                        Honza

---------------------------------------------------------------------
                           HoK Honza Kohout
student Fakulty Informatiky MU       clen 137. NRS Klubu Bludny koren
 http://honza.koren.cz/                         http://www.koren.cz/
  honza@koren.cz                                      klub@koren.cz


Re: Show all users

From
"A.Bhuvaneswaran"
Date:
>     I'm starting to PostgreSQL and during my tries I created several
> users and databases. I can see databases, but I can't see the users.
> And, of course, I will need to see all users in my applications.

=> \d pg_user -- would help you

regards,
bhuvaneswaran


Re: Show all users

From
Date:

select * from pg_shadow


regds
mallah.

> Have a nice day,
>
>    I'm starting to PostgreSQL and during my tries I created several
> users and databases. I can see databases, but I can't see the users. And, of course, I will
> need to see all users in my applications.
>
>
>                Thanks for answer
>
>                         Honza
>
> ---------------------------------------------------------------------
>                           HoK Honza Kohout
> student Fakulty Informatiky MU       clen 137. NRS Klubu Bludny koren
> http://honza.koren.cz/                         http://www.koren.cz/
>  honza@koren.cz                                      klub@koren.cz
>
>
> ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off
> all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)



-----------------------------------------
Get your free web based email at trade-india.com.
   "India's Leading B2B eMarketplace.!"
http://www.trade-india.com/