Re: Error when doing sql - Mailing list pgsql-novice

Hi Aruna,

                I have done what you suggested, and got a similar error with a “hint” this time

###############################

Traceback (most recent call last):

  File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site

-packages/sqlalchemy/engine/base.py", line 1244, in _execute_context

    cursor, statement, parameters, context

  File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site

-packages/sqlalchemy/engine/default.py", line 550, in do_execute

    cursor.execute(statement, parameters)

psycopg2.errors.UndefinedColumn: column "title" does not exist

LINE 1: ...ear", "Runtime", "imdbID", "imdbRating") VALUES ((title), (y...

                                                             ^

HINT:  Perhaps you meant to reference the column "movies.Title".

The above exception was the direct cause of the following exception:

Traceback (most recent call last):

  File "import.py", line 22, in <module>

    main()

  File "import.py", line 18, in main

    {"title": title, "year": year, "runtime": runtime, "imdbID": imdbID, "im

dbRating:": imdbRating }) # substitute values from CSV line into SQL command

, as per this dict

  File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site

-packages/sqlalchemy/engine/base.py", line 2166, in execute

    return connection.execute(statement, *multiparams, **params)

  File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site

-packages/sqlalchemy/engine/base.py", line 982, in execute

    return self._execute_text(object_, multiparams, params)

  File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site

-packages/sqlalchemy/engine/base.py", line 1155, in _execute_text

parameters,

  File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site

-packages/sqlalchemy/engine/base.py", line 1248, in _execute_context

    e, statement, parameters, cursor, context

  File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site

-packages/sqlalchemy/engine/base.py", line 1466, in _handle_dbapi_exception

    util.raise_from_cause(sqlalchemy_exception, exc_info)

  File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site

-packages/sqlalchemy/util/compat.py", line 383, in raise_from_cause

    reraise(type(exception), exception, tb=exc_tb, cause=cause)

  File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site

-packages/sqlalchemy/util/compat.py", line 128, in reraise

    raise value.with_traceback(tb)

  File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site

-packages/sqlalchemy/engine/base.py", line 1244, in _execute_context

cursor, statement, parameters, context

  File "/Library/Frameworks/Python.framework/Versions/3.7/lib/python3.7/site

-packages/sqlalchemy/engine/default.py", line 550, in do_execute

    cursor.execute(statement, parameters)

sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedColumn) column "t

itle" does not exist

LINE 1: ...ear", "Runtime", "imdbID", "imdbRating") VALUES ((title), (y...

                                                             ^

HINT:  Perhaps you meant to reference the column "movies.Title".

[SQL: INSERT INTO movies("Title", "Year", "Runtime", "imdbID", "imdbRating")

VALUES ((title), (year), (runtime), (imdbID), (imdbRating))]

[parameters: {'title': 'Title', 'year': 'Year', 'runtime': 'Runtime', 'imdbI

D': 'imdbID', 'imdbRating:': 'imdbRating\n'}]

(Background on this error at: http://sqlalche.me/e/f405)

Thanks,

Cravan

Cravan,

Postgres is case-sensitive, and the columns names in your insert statement should exactly match the table definition.

Your insert into statement should look like this, (surround the exact column name around double quotes)

Insert into movies(“Title”,”Year”, “Runtime”,”imdbID”, “imdbRating”)

Hi, here is the table:

\d+ tablename

This message (including any attachments) is confidential and intended for a specific individual and purpose. If you are not the intended recipient, please notify the sender immediately and delete this message.