problem creating users via pythons script

Поиск
Список
Период
Сортировка
От Timothy Smith
Тема problem creating users via pythons script
Дата
Msg-id 44BE1F45.7060403@open-networks.net
обсуждение исходный текст
Ответы Re: problem creating users via pythons script  (Volkan YAZICI <yazicivo@ttnet.net.tr>)
Список pgsql-general
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.


В списке pgsql-general по дате отправления:

Предыдущее
От: Q
Дата:
Сообщение: Re: Performance problem with query
Следующее
От: "Christian Rengstl"
Дата:
Сообщение: Re: Performance problem with query