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;

See also  How to delete an SQS queue from AWS CLI