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

INSERT without target column list is only a good idea for special cases. Typically, it is not since it is error-prone (in addition to your syntax error with the singele-quote). — Erwin Brandstetter
– Erwin Brandstetter, Commented Apr 13, 2016 at 1:11

Alfabravo · Accepted Answer · 2017-12-18 15:51:19Z

8

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

Alfabravo

7,5786 gold badges49 silver badges83 bronze badges

answered Apr 13, 2016 at 0:08

Anthony E

11.3k2 gold badges28 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1