PostgreSQL List Users

== create superuser & database ==
CREATE USER [username] SUPERUSER;
CREATE DATABASE [username] WITH OWNER [username];

== list all users ==
SELECT u.usename AS "User name",
  u.usesysid AS "User ID",
  CASE WHEN u.usesuper AND u.usecreatedb THEN CAST('superuser, create
database' AS pg_catalog.text)
    WHEN u.usesuper THEN CAST('superuser' AS pg_catalog.text)
    WHEN u.usecreatedb THEN CAST('create database' AS
pg_catalog.text)
    ELSE CAST('' AS pg_catalog.text)
  END AS "Attributes"
FROM pg_catalog.pg_user u
ORDER BY 1;

or

\du

== quit psql ==
\q

== edit configuration ==
- change pg_hba.conf (using MAMP + PostgreSQL stack)
  --> edit all from md5 to trust

== comment ==
problem with MAMP + PostgreSQL stack is that pgsqladmin doesn't recognize default user "postgres" or "root" or "administrator" by default.