Creating Table in PostgreSQL using PHP

I get a "parser: parse error at "(" on line... .... /path/to/script.php.

on the following code:

$db=pg_pconnect("dbname=my_db_name user=user_name") or die(pg_errormessage($db));
$sql="CREATE TABLE users (
id varchar(5),
name varchar(20),
middle varchar(20),
last varchar(20),
address varchar(50),
expir date,
pass varchar(20),
PRIMARY KEY(id)
)";
pg_exec($db, $sql) or die(pg_errormessage());

The error is on the LAST line of code above.

This is driving me NUTS as I don't see any obvious error in the code. Please help.

I haven't used Postgresql much, but in other databases you have to explicitly declare all parts of the Primay Key to be NOT NULL. But it would seem to me that if this was the problem you would be getting a different type of error message. ????

I don't see an obvious error in the code either.

Thanks dcaillouet, but I have already tried ...(id varchar(5) NOT NULL, ...)"; still didn't work!!

Should this line

pg_exec($db, $sql) or die(pg_errormessage());

be like the line earlier in the code?

pg_exec($db, $sql) or die(pg_errormessage($db));

I think it must be something like:

$link = pg_exec($db, $sql)
or die(pg_errormessage());

I finally got my PHP script(s) to work(creating tables). I found out when I declare NOT NULL it must be before the default value (if any)

i.e. ident vachar(5) NOT NULL DEFAULT 0,

and not:

ident varchar(5) DEFAULT '0' NOT NULL,

the default value must be without quotes.