RE: ERROR when inserting csv values into sql table
David Raymond <[email protected]> Thu, 13 Jun 2019 14:08:32 +0000
| Newsgroups | gmane.comp.db.postgresql.novice |
|---|---|
| Message-ID | <VI1PR07MB5792CC504D19198B54AA7EC087EF0@VI1PR07MB5792.eurprd07.prod.outlook.com> |
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)')