How to list all database users in Redshift

You can query pg_user system catalog table for a list of all the database users in Redshit database.

select usename from pg_user;