Postgres Pro
Downloads
Home   >   mailing lists

RE: ERROR when inserting csv values into sql table - Mailing list pgsql-novice

From David Raymond
Subject RE: ERROR when inserting csv values into sql table
Date
Msg-id VI1PR07MB5792CC504D19198B54AA7EC087EF0@VI1PR07MB5792.eurprd07.prod.outlook.com
Whole thread Raw
In response to Re: ERROR when inserting csv values into sql table  (Cravan <savageapple850@gmail.com>)
List pgsql-novice
Tree view 
LINE 1: INSERT INTO movies(title, year, runtime, 'imdbID', 'imdbRati...

You used single quotes for the part with column names. Double quotes are for identifies, single quotes are string
literals.So it looks like it need to be
 

insert_statement = sqlalchemy.text('INSERT INTO movies(title, year, runtime, "imdbID", "imdbRating") VALUES (:title,
:year,:runtime, :imdbID, :imdbRating)')

pgsql-novice by date:

Previous
From: Bzzzz
Date:
Subject: Re: ERROR when inserting csv values into sql table
Next
From: "Anthony E. Greene"
Date:
Subject: Re: ERROR when inserting csv values into sql table