PostgreSQL - Syntax error at or near

Question

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

Answer 1

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