Обсуждение: psycopg problem

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

On Aug 10 07:57, Roger Mason wrote:
> run = "S90040"
> curs.execute("create table %s (date text, tset text)",(run,))

Please see this[1] and this[2].

[1] http://archives.postgresql.org/pgsql-general/2006-07/msg00706.php
[2] http://archives.postgresql.org/pgsql-general/2006-07/msg00707.php


Regards.

Volkan YAZICI <yazicivo@ttnet.net.tr> writes:

> On Aug 10 07:57, Roger Mason wrote:
>> run = "S90040"
>> curs.execute("create table %s (date text, tset text)",(run,))
>
> Please see this[1] and this[2].
>
> [1] http://archives.postgresql.org/pgsql-general/2006-07/msg00706.php
> [2] http://archives.postgresql.org/pgsql-general/2006-07/msg00707.php

Thanks very much.  I should have found this myself!

Roger