gistfile1.txt

vagrant@lucid32:~$ sudo su postgres
postgres@lucid32:/home/vagrant$ psql
psql (8.4.8)
Type "help" for help.

postgres=# SELECT * FROM pg_user;
 usename  | usesysid | usecreatedb | usesuper | usecatupd |  passwd  | valuntil | useconfig 
----------+----------+-------------+----------+-----------+----------+----------+-----------
 postgres |       10 | t           | t        | t         | ******** |          | 
 rails    |    16385 | t           | t        | t         | ******** |          | 
 vagrant  |    24578 | t           | t        | t         | ******** |          | 
(3 rows)

postgres=# SELECT * FROM pg_roles;
 rolname  | rolsuper | rolinherit | rolcreaterole | rolcreatedb | rolcatupdate | rolcanlogin | rolconnlimit | rolpassword | rolvaliduntil | rolconfig |  oid  
----------+----------+------------+---------------+-------------+--------------+-------------+--------------+-------------+---------------+-----------+-------
 postgres | t        | t          | t             | t           | t            | t           |           -1 | ********    |               |           |    10
 rails    | t        | t          | t             | t           | t            | t           |           -1 | ********    |               |           | 16385
 vagrant  | t        | t          | t             | t           | t            | t           |           -1 | ********    |               |           | 24578
(3 rows)