conn = psycopg2.connect("dbname=<mydbname> user=postgres password=<mypassword>")
cur = conn.cursor()
output = StringIO.StringIO()
output.write('Citizen CainetMy_API_idn')
cur.copy_from(output, 'movie', columns=('title','api_id'))
conn.commit()

output.seek(0) #put the position of the buffer at the beginning