RE: Error when doing sql - Mailing list pgsql-novice
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@gmail.com>
Sent: Wednesday, June 12, 2019 8:07 AM
To: Adarsh Jaiswal <adarshjaiswal1989@gmail.com>
Cc: pgsql-novice@postgresql.org
Subject: Re: Error when doing sql
Hi, here is the table:
From: Adarsh Jaiswal <adarshjaiswal1989@gmail.com>
Date: Wednesday, 12 June 2019 at 8:36 PM
To: cool kid <savageapple850@gmail.com>
Cc: "pgsql-novice@postgresql.org" <pgsql-novice@postgresql.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.
Attachment
pgsql-novice by date: