RE: Error when doing sql

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”)

Thank you,

Aruna Gubba

From: Cravan <savageapple850(at)gmail(dot)com>
Sent: Wednesday, June 12, 2019 8:07 AM
To: Adarsh Jaiswal <adarshjaiswal1989(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Error when doing sql

Hi, here is the table:[cid:image001(dot)png(at)01D520F6(dot)532A9180]

From: Adarsh Jaiswal <adarshjaiswal1989(at)gmail(dot)com<mailto:adarshjaiswal1989(at)gmail(dot)com>>
Date: Wednesday, 12 June 2019 at 8:36 PM
To: cool kid <savageapple850(at)gmail(dot)com<mailto:savageapple850(at)gmail(dot)com>>
Cc: "pgsql-novice(at)postgresql(dot)org<mailto:pgsql-novice(at)postgresql(dot)org>" <pgsql-novice(at)postgresql(dot)org<mailto:pgsql-novice(at)postgresql(dot)org>>
Subject: Re: Error when doing sql

\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.