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

Answer 1

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

SET SEARCH_PATH TO work;