current community

your communities

more stack exchange communities

Stack Exchange
tour help
Take the 2-minute tour ×
Unix & Linux Stack Exchange is a question and answer site for users of Linux, FreeBSD and other Un*x-like operating systems. It's 100% free, no registration required.
up vote 0 down vote favorite

There are createuser & dropuser commands:

createuser - define a new PostgreSQL user account
dropuser - remove a PostgreSQL user account

Is there a corresponding way to list the user accounts?

These two commands do not require the user to invoke psql nor understand details of using it.

share|improve this question
    
lmgtfy.com/?q=How+to+list+user+accounts+in+postgres :( –  SailorCire May 6 at 0:05
    
@SailorCire, so, you apparently see no difference in the question you asked lmgtfy and the one I posted here. That is one of the niceties of so.com, questions and answers can be improved over time with feedback from others. –  C.W.Holeman II May 6 at 1:57
    
Yes, one of the goals of any SE is to become the Q&A for a certain topic; however, as per Help Center research should be done prior to asking as well as being specific. Your edit has now removed some ambiguity. –  SailorCire May 6 at 2:14

1 Answer 1

up vote 1 down vote

usq psql shell and :

\deu[+] [PATTERN] such as :

postgres=# \deu+
      List of user mappings
 Server | User name | FDW Options 
--------+-----------+-------------
(0 rows)

And for all users:

postgres=# \du 
                              List of roles
 Role name  |                   Attributes                   | Member of 
------------+------------------------------------------------+-----------
 chpert.net |                                                | {}
 postgres   | Superuser, Create role, Create DB, Replication | {}
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.