Psql table error

sri2002

This is my psql table query and I am not able to execute this:
CREATE TABLE FieldPartnership (
FieldPartnershipID smallint(4) NOT NULL default '0',
FInstWide smallint(4) NOT NULL default '0',
FHealth smallint(4) NOT NULL default '0',
FEduc smallint(4) NOT NULL default '0',
FHuman smallint(4) NOT NULL default '0',
FBusi smallint(4) NOT NULL default '0',
FSocSci smallint(4) NOT NULL default '0',
FComm smallint(4) NOT NULL default '0',
FInfoTech smallint(4) NOT NULL default '0',
FArts smallint(4) NOT NULL default '0',
FIntl smallint(4) NOT NULL default '0',
FNatSci smallint(4) NOT NULL default '0',
FAgNR smallint(4) NOT NULL default '0',
FAdmin smallint(4) NOT NULL default '0',
FLaw smallint(4) NOT NULL default '0',
FOther smallint(4),
PRIMARY KEY (FieldPartnershipID)
);
It throws an error:
parser: parse error at or near "("

I am converting this table script from Mysql to psql.
Any ideas/thoughts!
Thanks
Sri

jeremuck

use backticks ` (same key as tilde) around all of your table and field names.

(that drove me crazy before I figured it out.

table
field1....

sri2002

Hi thanks for that but now I am getting this error:
parser: parse error at or near "`"

CREATE TABLE FieldPartnership (
FieldPartnershipID smallint(4) NOT NULL default '0',
FInstWide smallint(4) NOT NULL default '0',
FHealth smallint(4) NOT NULL default '0',
FEduc smallint(4) NOT NULL default '0',
FHuman smallint(4) NOT NULL default '0',
FBusi smallint(4) NOT NULL default '0',
FSocSci smallint(4) NOT NULL default '0',
FComm smallint(4) NOT NULL default '0',
FInfoTech smallint(4) NOT NULL default '0',
FArts smallint(4) NOT NULL default '0',
FIntl smallint(4) NOT NULL default '0',
FNatSci smallint(4) NOT NULL default '0',
FAgNR smallint(4) NOT NULL default '0',
FAdmin smallint(4) NOT NULL default '0',
FLaw smallint(4) NOT NULL default '0',
FOther smallint(4),
PRIMARY KEY (FieldPartnershipID)
);

Lars_Berg

Stay clear of the backticks, that's just some mysql shenaningan.

Smallint does not take any qualifier and the default value should be of a type that is comparable to smallint.

FieldPartnershipID smallint NOT NULL default 0,

ultraslacker

Also, don't bother with the hungarian notation (caps). Keep it lowercase.

sri2002

Ouch...Still erroring out as :parser: parse error at or near "("
Code now is:
CREATE TABLE FieldPartnership (
FieldPartnershipID smallint(4) NOT NULL default 0,
FInstWide smallint(4) NOT NULL default 0,
FHealth smallint(4) NOT NULL default 0,
FEduc smallint(4) NOT NULL default 0,
FHuman smallint(4) NOT NULL default 0,
FBusi smallint(4) NOT NULL default 0,
FSocSci smallint(4) NOT NULL default 0,
FComm smallint(4) NOT NULL default 0,
FInfoTech smallint(4) NOT NULL default 0,
FArts smallint(4) NOT NULL default 0,
FIntl smallint(4) NOT NULL default 0,
FNatSci smallint(4) NOT NULL default 0,
FAgNR smallint(4) NOT NULL default 0,
FAdmin smallint(4) NOT NULL default 0,
FLaw smallint(4) NOT NULL default 0,
FOther smallint(4),
PRIMARY KEY (FieldPartnershipID)
);

Help pls!!

sri2002

that worked thanks a lot....smallint(4) is bad smallint worked...