global_object_quotes_escape_tests.sql

create role x;
comment on role x is $$"'😊;""'$$;
ALTER ROLE x IN DATABASE template1 SET client_min_messages = 'DEBUG';
ALTER ROLE x SET maintenance_work_mem = 100000;
CREATE ROLE x1 WITH LOGIN PASSWORD 'jw8s0F4' VALID UNTIL '2005-01-01';
comment on role x1 is $$"';"''
$$;

CREATE ROLE x2 WITH LOGIN PASSWORD 'jw8s0F"4';
comment on role x2 is $$';"$$;

create role y;
comment on role y is $$;"'$$;
create role "'";
create role "'';";
create role "';;;';";
create role z;
comment on role z is $$"";';$$;

create role ";
';
;
";
create role ";";
comment on role ";" is $$;"';',",' $$;
comment on role ";" is $$;"';',",' 

$$;

create role "

";
comment on role z is $$;"';',",'';;'"";$$;