CODEWITHSUNDEEP
sqlpostgresqlsyntax-error
user146303
user146303

Reputation: 437

PostgreSQL - Syntax error at or near

There are a lot of questions like this, but I couldn't find one that solved my problem-

Can someone tell me if my syntax is wrong? I'm trying to insert data into a sql table.

INSERT INTO awards values ('Academy of Motion Picture Arts and Sciences’,'2007',’Best Picture','Oscar’);

I'm getting this error:

ERROR:  syntax error at or near "2007"
LINE 1: ...s ('Academy of Motion Picture Arts and Sciences’,'2007',’Bes...

Upvotes: 4

Views: 27759

Answers (1)

Anthony E
Anthony E

Reputation: 11235

Did you paste this from somewhere? Check and replace your quote character, you're using an invalid character (e.g. ’ instead of ') for quoting.

Upvotes: 8

Related Questions