Adam wrote:
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"))
"privilege" integer(2) NOT NULL Postgres doesn't support integers of different sizes like this. http://www.postgresql.org/docs/8.1/interactive/datatype.html#DATATYPE-INT -- Postgresql & php tutorials http://www.designmagick.com/ ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
