title: Psycopg2 Insert Into Table with Placeholders
body: <p>This might be a rather silly question but what am I doing wrong here? It creates the table but the INSERT INTO doesn't work, I guess I'm doing something wrong with the placeholders?</p>
  
  <pre><code>conn = psycopg2.connect("dbname=postgres user=postgres")
  cur = conn.cursor()
  escaped_name = "TOUR_2"
  cur.execute('CREATE TABLE %s(id serial PRIMARY KEY, day date, elapsed_time varchar,    net_time varchar, length float, average_speed float, geometry GEOMETRY);' % escaped_name)
  
  cur.execute('INSERT INTO %s (day,elapsed_time, net_time, length, average_speed, geometry) VALUES (%s, %s, %s, %s, %s, %s)', (escaped_name, day ,time_length,  time_length_net, length_km, avg_speed,  myLine_ppy))
  
  conn.commit()
  cur.close()
  conn.close()
  </code></pre>
  
  <p>The INSERT INTO call doesn't work, it gives me</p>
  
  <pre><code>cur.execute('INSERT INTO %s (day,elapsed_time, net_time, length, average_speed,  
  geometry) VALUES (%s, %s, %s, %s, %s, %s)'% (escaped_name, day ,time_length,  
  time_length_net, length_km, avg_speed,  myLine_ppy))
  psycopg2.ProgrammingError: syntax error at or near ":"
  LINE 1: ...h, average_speed, geometry) VALUES (2013/09/01 , 2:56:59, 02...
  </code></pre>
  
  <p>Can someone help me on this one? Thanks a bunch!</p>