|
|
|
|
|
|
| Author |
Message |
Timothy Smith
*nix forums addict
Joined: 16 Apr 2005
Posts: 61
|
 Posted: Wed Jul 19, 2006 1:16 pm Post subject:
Re: problem creating users via pythons script
|
|
|
Volkan YAZICI wrote:
| Quote: | On Jul 19 10:40, Timothy Smith wrote:
Volkan YAZICI wrote:
On Jul 19 10:02, Timothy Smith wrote:
cur.execute("""CREATE USER %s WITH PASSWORD %s IN GROUP %s
""",(StaffUserName,NewPassword,StaffGroup))
produces this error
ERROR: syntax error at or near "'bob.smith'" at character 13
IIRC, per Python DB-API PEP, the DB adapter you use try to escape and
quote any parameter you specified. Please try to use python parameters,
that are "% (param1, param2, ...)", only for values; not for any other
Edit: «% (param1, param2, ...)» part must be replaced with
«"query_str", param1, param2, ...»
place in the query string.
To summarize, you can only use parameters for values, not keys.
...
ah ok so how do i do it :/
Just don't pass username as parameter to Cursor.execute(), for instance:
cur.execute("CREATE USER %s WITH PASSWORD %s IN GROUP %s"
% (StaffUserName, NewPassword, StaffGroup))
Regards.
P.S. Please don't forget to CC mailing list next time. Also, -interface
ml is more appropriate for these kind of questions.
of course, i should have seen that to begin with, cheers. |
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly |
|
| Back to top |
|
 |
Volkan YAZICI
*nix forums beginner
Joined: 13 Jun 2005
Posts: 31
|
| Posted: Wed Jul 19, 2006 12:50 pm Post subject:
Re: problem creating users via pythons script
|
|
|
On Jul 19 10:40, Timothy Smith wrote:
| Quote: | Volkan YAZICI wrote:
On Jul 19 10:02, Timothy Smith wrote:
cur.execute("""CREATE USER %s WITH PASSWORD %s IN GROUP %s
""",(StaffUserName,NewPassword,StaffGroup))
produces this error
ERROR: syntax error at or near "'bob.smith'" at character 13
IIRC, per Python DB-API PEP, the DB adapter you use try to escape and
quote any parameter you specified. Please try to use python parameters,
that are "% (param1, param2, ...)", only for values; not for any other
|
Edit: «% (param1, param2, ...)» part must be replaced with
«"query_str", param1, param2, ...»
| Quote: | place in the query string.
To summarize, you can only use parameters for values, not keys.
...
ah ok so how do i do it :/
|
Just don't pass username as parameter to Cursor.execute(), for instance:
cur.execute("CREATE USER %s WITH PASSWORD %s IN GROUP %s"
% (StaffUserName, NewPassword, StaffGroup))
Regards.
P.S. Please don't forget to CC mailing list next time. Also, -interface
ml is more appropriate for these kind of questions.
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings |
|
| Back to top |
|
|
Volkan YAZICI
*nix forums beginner
Joined: 13 Jun 2005
Posts: 31
|
| Posted: Wed Jul 19, 2006 12:13 pm Post subject:
Re: problem creating users via pythons script
|
|
|
On Jul 19 10:02, Timothy Smith wrote:
| Quote: | cur.execute("""CREATE USER %s WITH PASSWORD %s IN GROUP %s
""",(StaffUserName,NewPassword,StaffGroup))
produces this error
ERROR: syntax error at or near "'bob.smith'" at character 13
|
IIRC, per Python DB-API PEP, the DB adapter you use try to escape and
quote any parameter you specified. Please try to use python parameters,
that are "% (param1, param2, ...)", only for values; not for any other
place in the query string.
To summarize, you can only use parameters for values, not keys.
Regards.
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq |
|
| Back to top |
|
|
Timothy Smith
*nix forums addict
Joined: 16 Apr 2005
Posts: 61
|
| Posted: Wed Jul 19, 2006 12:02 pm Post subject:
problem creating users via pythons script
|
|
|
this is really newb of me but i can't manage to make a script to create
users.
cur.execute("""CREATE USER %s WITH PASSWORD %s IN GROUP %s
""",(StaffUserName,NewPassword,StaffGroup))
produces this error
ERROR: syntax error at or near "'bob.smith'" at character 13
is it because i need to double quote or something? i'm sure the answer
is stupid and i'm just too tired.
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org |
|
| Back to top |
|
|
Google
|
|
| Back to top |
|
|
|
|
The time now is Thu Dec 04, 2008 2:01 am | All times are GMT
|
|
Credit Cards | Online Advertising | Web Advertising | Credit Report | Loan
|
|
Copyright © 2004-2005 DeniX Solutions SRL
|
|
|
|
Other DeniX Solutions sites:
Unix/Linux blog |
electronics forum |
medicine forum |
science forum |
|
|
Privacy Policy
|
Powered by phpBB © 2001, 2005 phpBB Group
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Forum index
»
Databases
»
PostgreSQL
