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