Use "CREATE USER" in plpgsql function
От | Tatarnikov Alexander |
---|---|
Тема | Use "CREATE USER" in plpgsql function |
Дата | |
Msg-id | AANLkTi=u7vWFrgTzzE5zXUoT=4vqQt1tSH-A+s-K=JzU@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Use "CREATE USER" in plpgsql function
Re: Use "CREATE USER" in plpgsql function |
Список | pgsql-sql |
Hello!<br /><br />I have function wich check user credentials and if test passed function must create new user with generatedusername and password.<br /><br />Language is plpgsql.<br clear="all" /><br />For example:<br /><br />....<br />DECLAREcreds RECORD;<br /> ...<br />SELECT * INTO creds FROM ...<br /><br />creds is Record with fields userName(VARCHAR)and userPassword(VARCHAR)<br /><br />so when i use CREATE USER creds."userName" WITH PASSWORD creds."userPassword"<br/><br />i get an error, because creds."userName" is VARCHAR and thus when function runs it will belook like this:<br />CREATE USER 'user_1' <br />but right command is <br />"CREATE USER user_1" OR " CREATE USER "user_1""<br /><br />so question is how to "unembrace" this parameter (i mean creds."userName")?<br /><br />Thanks<br />--<br />------<br />Alexander<br />
В списке pgsql-sql по дате отправления: