Passing in parameters enclosed in double quotes

Поиск
Список
Период
Сортировка
От Brent Hoover
Тема Passing in parameters enclosed in double quotes
Дата
Msg-id CAJytaR5CSBNz6JUu=wxV7_D22T2Y=m66d8y2fT3MEPCq0hvyPw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Passing in parameters enclosed in double quotes  (Federico Di Gregorio <fog@dndg.it>)
Список psycopg
Hello,

I am sure this is in the documentation somewhere, but I am stumped as to where.

I am trying to pass in a table name to reset a series of sequences.

conn_cursor.execute("""SELECT setval(pg_get_serial_sequence("%s", %s), 1, false);""", ( _column[0]), _column[1],))

where _column[0] is a table name, and _column[1] is a column name. So the table name needs to be directly enclosed in double-quotes, but the psycopg2 adapter is adding single quotes inside that. So instead of getting "table_name" I get "'table_name'" which does not work. I feel like is probably an issue of escaping the quotes somehow but I cannot figure out how. Psycopg2's behavior is completely correct here, it sees a string and wraps it in quotes, but this case of wanting to access a table name is somewhat of a special case.

Thanks so much for such a great piece of software.


Brent Hoover
Computer Scientist

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

Предыдущее
От: Federico Di Gregorio
Дата:
Сообщение: Re: RFC: Extend psycopg2.connect to accept all valid parameters?
Следующее
От: Federico Di Gregorio
Дата:
Сообщение: Re: Passing in parameters enclosed in double quotes