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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: 9.0rc1 - query of view produces unexpected results
Следующее
От: Sergey Konoplev
Дата:
Сообщение: Re: Use "CREATE USER" in plpgsql function