I want to create a table and for whatever reason it will not accept the command, can anyone say what is wrong as I am very new to Postgres, thanks:
CREATE TABLE cmpnycontacts ( ContactNo integer(10) NOT NULL SERIAL, CmpnyNo varchar(6) NOT NULL, FirstName varchar(30) NOT NULL, Surname varchar(30) NOT NULL, Phone varchar(20) NOT NULL, Mobile varchar(20) NOT NULL, Email varchar(40) NOT NULL, Country char(2) NOT NULL, CONSTRAINT cmpnycontacts_pkey PRIMARY KEY (ContactNo) ); ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
