Error with ALTER TABLE %s
[email protected] Tue, 4 May 2010 13:54:18 +0200
| Newsgroups | gmane.comp.python.db.psycopg.devel |
|---|---|
| Message-ID | <[email protected]> |
Hi, when I do
SQL = "ALTER TABLE films ADD COLUMN (%s) text;"
data = ("test3", )
cur.execute(SQL,data)
I get this error,
LINE 1: ALTER TABLE films ADD COLUMN (E'test3') text;
python 2.6 | Psycopg 2.0.14
-HWK