Re: [SQL] Stupid Question

2001-10-02 Thread Devrim GUNDUZ
<<< No Message Collected >>> ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly

Re: [SQL] Stupid Question

2001-10-02 Thread Nils Zonneveld
Rebekah Kirk wrote: > > 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 v

[SQL] Stupid Question

2001-10-02 Thread Rebekah Kirk
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)