Stupid Question - Mailing list pgsql-sql

From Rebekah Kirk
Subject Stupid Question
Date
Msg-id 9pc2t6$31ga$1@news.tht.net
Whole thread Raw
Responses Re: Stupid Question  (Devrim GUNDUZ <devrim@oper.metu.edu.tr>)
List pgsql-sql
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)
);





pgsql-sql by date:

Previous
From: bpalmer
Date:
Subject: faster and faster!!
Next
From: "sreedhar"
Date:
Subject: