psql query problem.

sri2002

I am creating a query to create table in psql. This is my code:
CREATE TABLE msu9900 (
ID serial NOT NULL primary key,
LastName varchar(20) NULL,
FirstName varchar(20)NULL,
Street varchar(40) NULL,
City varchar(40) NULL,
State varchar(20) NULL,
Zip varchar(50) NULL,
HomePhone varchar(20) NULL,
WorkPhone varchar(20) NULL,
Email varchar(35) NULL,
Major varchar(30) NULL,
GradDate date NULL,
DateAvail date NULL,
USCitizen tinyint(4) NULL,
WantsInfo tinyint(4) NULL,
Languages varchar(60) NULL,
ServYrs varchar(25) NULL,
Country varchar(30) NULL,
AArea varchar(20) NULL,
Occupation varchar(30) NULL,
Employer varchar(30) NULL,
WorkStreet varchar(30) NULL,
WorkCity varchar(40) NULL,
WorkZip varchar(20) NULL,
WorkState varchar(20) NULL,
Talks tinyint(4) NULL,
StatusIList varchar(20) NULL,
StatusIIList varchar(30) NULL,
Notes varchar(190) NULL,
RecordDate date NULL,

);
Table does not get created. Any thouhts ideas?
Thanks
Sri

sri2002

error is parse erro at or near "("

[deleted]

Try leaving out all the NULL's.

NOT NULL is a statement, NULL is a value.

[deleted]

Oh, and ofcourse the comma after the final column may be a bit of a mistake 😃

sri2002

What do you mean by this? Make all the NULL's not Null or all Not Null's to NULLs
Thanks
Sri

[deleted]

'NOT NULL' means that the field cannot contain a NULL value.

If you do want to be avble to put NULL values in the field, you should simply not define it to be 'NOT NULL'

field cannot be NULL:
LastName varchar(20) NOT NULL,

field can be NULL:
LastName varchar(20)

Bad syntax:
LastName varchar(20) NULL

sri2002

Thanks much for pointing this out. But I am till getting errors
CREATE TABLE msu9900 (
ID serial NOT NULL primary key,
LastName varchar(20),
FirstName varchar(20),
Street varchar(40),
City varchar(40),
State varchar(20),
Zip varchar(50),
HomePhone varchar(20),
WorkPhone varchar(20),
Email varchar(35),
Major varchar(30),
GradDate date,
DateAvail date,
USCitizen tinyint(4),
WantsInfo tinyint(4),
Languages varchar(60),
ServYrs varchar(25),
Country varchar(30),
AArea varchar(20),
Occupation varchar(30),
Employer varchar(30),
WorkStreet varchar(30),
WorkCity varchar(40),
WorkZip varchar(20),
WorkState varchar(20),
Talks tinyint(4),
StatusIList varchar(20),
StatusIIList varchar(30),
Notes varchar(190),
RecordDate date
);
ERROR: parser: parse error at or near "("
Any thoughts/ideas?
Thanks
Sri

[deleted]

There is no tinyint in pgsql, use an int2 instead, and in pgsql there are no () after integer types, it's just int4 or int2.

sri2002

Thanks that worked.