[Gambas-user] simple postgres create user question

[richard terry]

Something simple - I can do the equivalent of this  this in a pgadmin window:

CREATE USER  "FRED"'   PASSWORD 'password' in ROLE whatever; and it keeps the 
caps of FRED

I alwasy end up with lower case letters for the user name when I pass the 
query to postgres

even if the logon_name here is "FRED" it > lower case and if I enclose in ' ' 
or $$ characters etc bombs

 sql = "CREATE USER " & staff!logon_name & " PASSWORD $$" & staff!password & 
"$$ IN ROLE " & role

Any help appreciated.

richard