I'm trying to create a table and I'm getting this error:

     SQL error:


ERROR:  syntax error at or near "(" at character 39
     In statement:
CREATE TABLE "users" ("user_ID" SERIAL(12), "first_name" character varying(40) NOT NULL, "last_name" character varying(40) NOT NULL, "password" character varying(16) NOT NULL, "email" character varying(100) NOT NULL, "privilege" integer(2) NOT NULL, PRIMARY KEY ("user_ID"))



     What's wrong with this SQL?



---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to