SEO

#1 (**permalink**) 04-09-2008, 10:58 AM

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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

#2 (**permalink**) 04-09-2008, 10:58 AM

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...7/msg00706.php
[2] http://archives.postgresql.org/pgsql...7/msg00707.php

Regards.

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

#3 (**permalink**) 04-09-2008, 10:58 AM

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...7/msg00706.php
> [2] http://archives.postgresql.org/pgsql...7/msg00707.php

Thanks very much. I should have found this myself!

Roger

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

psycopg problem