[BangPypers] psycopg2 problem

Anand Chitipothu anandology at gmail.com
Mon Oct 26 12:45:12 CET 2009


>>
> Right .
> Any how I am facing new problem now. See the error. Any hint ?
>
>   dbcursor.execute( "SELECT id,text FROM %s " ) % indbtname
> psycopg2.ProgrammingError: syntax error at or near "%"
> LINE 1: SELECT id,text FROM %s

You should construct the query first and then pass the query as
argument to execute function.

I suggest you to go through basic python tutorial before trying some
serious programming. Python Tutorial is best place to start.

http://docs.python.org/tutorial/index.html

Anand


More information about the BangPypers mailing list