RE: Error when doing sql

"Gubba, Aruna" <[email protected]> Wed, 12 Jun 2019 13:10:41 +0000
Newsgroups gmane.comp.db.postgresql.novice
Message-ID <[email protected]>
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 <[email protected]>
Sent: Wednesday, June 12, 2019 8:07 AM
To: Adarsh Jaiswal <[email protected]>
Cc: [email protected]
Subject: Re: Error when doing sql

Hi, here is the table:[cid:[email protected]]

From: Adarsh Jaiswal <[email protected]<mailto:[email protected]>>
Date: Wednesday, 12 June 2019 at 8:36 PM
To: cool kid <[email protected]<mailto:[email protected]>>
Cc: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[email protected]>>
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.
image001.png (image/png, 50.2 KB) - not displayed