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

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-general @
categoriespostgresql
postedAug 10, '06 at 10:27a
activeAug 10, '06 at 11:01a
posts3
users2
websitepostgresql.org
irc#postgresql

2 users in discussion

Roger Mason: 2 posts Volkan YAZICI: 1 post

People

Translate

site design / logo © 2022 Grokbase