postgreSQL syntax error at or near "INSERT"

Question

Here is my code:

SET SEARCH_PATH TO work

/* Task 1 */

INSERT INTO Category (CategoryID, Name, CategoryType)    

VALUES(1,'English','fiction');

and here is the error:

ERROR:  syntax error at or near "INSERT"
LINE 4: INSERT INTO Category (CategoryID,Name,CategoryType)
          ^
********** Error **********

ERROR: syntax error at or near "INSERT"
SQL state: 42601
Character: 45

The statement is valid. Which tool are you using to run that? Do you maybe have another statement in the editor before that which you did not properly terminate with a ;? — user330315
– user330315, Commented Apr 26, 2016 at 21:19
You need to end every statement with ; - including the set statement — user330315
– user330315, Commented Apr 26, 2016 at 21:30

Ray O'Donnell · Accepted Answer · 2017-03-09 18:43:00Z

7

You need a semi-colon at the end of the SET statement:

SET SEARCH_PATH TO work;

answered Mar 9, 2017 at 18:43

Ray O'Donnell

7814 silver badges12 bronze badges

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

Comments

Berra2k · Accepted Answer · 2016-04-26 22:02:48Z

3

Try to just do an insert into that is schema qualified:

INSERT INTO work.Category (CategoryID, Name, CategoryType)    

VALUES(1,'English','fiction');

Or

SET SEARCH_PATH TO work;

/* Task 1 */

INSERT INTO Category (CategoryID, Name, CategoryType)    

VALUES(1,'English','fiction');

Either should fix the error.

edited Apr 26, 2016 at 22:02

answered Apr 26, 2016 at 21:33

Berra2k

3382 gold badges5 silver badges17 bronze badges

Collectives™ on Stack Overflow

postgreSQL syntax error at or near "INSERT"

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related