Here's the query:
CREATE TABLE project_request (submit_date date ,
projectid serial ,
contact varchar not null ,
department varchar not null ,
telephone varchar not null ,
email varchar not null ,
project_name varchar not null ,
projectgoal1 varchar not null ,
projectgoal2 varchar ,
projectgoal3 varchar ,
projectgoal4 varchar ,
projectgoal5 varchar ,
projectgoal6 varchar ,
projectgoal7 varchar ,
PRIMARY KEY (projectid),
INDEX (projectid, project_name, email),
UNIQUE (projectid, project_name));
Here's the error I message I get:
ERROR: parser: parse error at or near "("
Please respond by email, as I am currently unable to get the list here at
work. (Curse those corprate amerver sysadmins!)
TIA!
Kevin J. Jackson
Internet Support/Development Specialist
TWA
kjjacks@twa.com
http://www.twa.com