CREATE TABLE emp2
(
eid integer NOT NULL,
fname text NOT NULL,
lname text NOT NULL,
age integer NOT NULL,
address character(100),
salary real,
CONSTRAINT emp2_pkey PRIMARY KEY (eid)
);
EOF;
$ret = pg_query($db, $sql);
if(!$ret){
echo pg_last_error($db);
} else {
echo "Table em2 created successfully\n";
}
echo"<br/> em2 table created and db closed" ;
pg_close($db);
