Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
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)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment