select * from pg_catalog.pg_roles;

oder besser gleich

  select 'create role '|| rolname ||';'
  from pg_catalog.pg_roles;