psycopg problem

Roger Mason <rmason@xxxxxxxxxx> · Thu, 10 Aug 2006 07:57:20 -0230

Hello,

I'm trying to use psycopg2 to create tables in a database using:

run = "S90040"
curs.execute("create table %s (date text, tset text)",(run,))

but it fails with

Traceback (most recent call last):
  File "write_xy_to_pg_psyco.py", line 44, in ?
    curs.execute("create table %s (date text, tset text)",(run,))
psycopg2.ProgrammingError: syntax error at or near "'S90040'" at
  character 14

If I run

curs.execute("create table S90040 (date text, tset text)",(run,))

it works perfectly, so I assume the quoting is messed up.

Could someone please tell me what I'm doing wrong?

Thanks,

Roger Mason