gistfile1.sql

CREATE OR REPLACE FUNCTION create_user_roles()
RETURNS void
AS $$
DECLARE
  row RECORD;
  role_name TEXT;
  role_password TEXT;
BEGIN
  FOR row IN (SELECT id FROM person) LOOP
    role_name := concat('Role', row.id);
    role_password := md5('row.id');
    EXECUTE $foo$CREATE ROLE $foo$ || quote_ident(role_name) || $foo$ WITH LOGIN NOSUPERUSER PASSWORD '$foo$ || role_password ||  $foo$' IN ROLE enduser;$foo$;
  END LOOP;
END;
$$ LANGUAGE plpgsql
SECURITY DEFINER;