Use "CREATE USER" in plpgsql function - Mailing list pgsql-sql

From Tatarnikov Alexander
Subject Use "CREATE USER" in plpgsql function
Date
Msg-id AANLkTi=u7vWFrgTzzE5zXUoT=4vqQt1tSH-A+s-K=JzU@mail.gmail.com
Whole thread Raw
Responses Re: Use "CREATE USER" in plpgsql function  (Sergey Konoplev <gray.ru@gmail.com>)
Re: Use "CREATE USER" in plpgsql function  ("Igor Neyman" <ineyman@perceptron.com>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: 9.0rc1 - query of view produces unexpected results
Next
From: Sergey Konoplev
Date:
Subject: Re: Use "CREATE USER" in plpgsql function