title: How to insert a python list into Postgres table
body: <p>I am trying to determine the simplest way to insert data from a python list into a PostgreSQL table.</p>
  
  <p>My PostgreSQL table was created as follows;</p>
  
  <pre><code>CREATE TABLE results(Id serial primary key, T0 timestamp, T1 real, T2 real, T3 real, T4 real, Total real, Result text);
  </code></pre>
  
  <p>My python list is formatted as follows;</p>
  
  <pre><code>ResultsList = ['2015-07-20 16:06:05', 0.16, 5.22, 5.81, 0.69, 11.90, 'OK']
  </code></pre>
  
  <p>I am using the following python code to write the list into the results table;</p>
  
  <pre><code>import psycopg2 as dbapi
  con = dbapi.connect(database='xxx', user='xxx')
  cur = con.cursor()
  cur.execute("INSERT into results VALUES (%s);", (ResultsList),)
  con.commit()
  </code></pre>
  
  <p>The interpreter spits out the following error;</p>
  
  <pre><code>Error not all arguments converted during string formatting
  Process finished with exit code 0
  </code></pre>
  
  <p>Any clues would be appreciated.</p>
  
  <p>Thanks :)</p>