strings to rows

gistfile1.txt

Select 'CREATE ROLE '|| user1||' LOGIN  NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION;' as createStat, 
'ALTER ROLE '|| user1 ||' SET search_path = qtg;' as al1, 
'ALTER ROLE '|| user1 ||' SET lock_timeout = ''60s'';' as al2, 
'GRANT adhocgrp TO '||user1 || ';' as grant1, 'alter role ' || user1||' with password ''' ||password1 ||''';'
From (
select 'adhoc'||a  as user1, left(md5( 'adhoc'||a|| inet_server_addr()),5)  password1, 'Drop user '||'adhoc'||a  ||';'
, 'COMMENT ON ROLE ' ||'adhoc'||a ||''' adhoc id for '||pg_catalog.shobj_description(b.oid, 'pg_authid') || ''';'
From (
select unnest(string_to_array(lower('TSDH2,TNXJ4,TDJS1,TAMG1,TPBW1,TJXB1,TJPH2,TOXM1'), ','))a 
) A
left join pg_roles b on 
a.a = b.rolname
) B