<?php
//require will produce a fatal error (E_COMPILE_ERROR) and stop the script
//include will only produce a warning (E_WARNING) and the script will continue
include 'connect_pgsdemo1.php';
$db = pg_connect( "host=$host dbname=$db user=$user password=$pass" );
if(!$db){
echo "Error : Unable to open database\n";
} else {
echo "Opened database successfully <br/>";
}

echo "<br/> table dropped if existed <br/>";
$sql =<<<EOF
CREATE TABLE IF NOT EXISTS COMPANY2
(ID INT PRIMARY KEY NOT NULL,
NAME TEXT NOT NULL,
AGE INT NOT NULL,
ADDRESS CHAR(50),
SALARY REAL);
EOF;
$ret = pg_query($db, $sql);
if(!$ret){
echo pg_last_error($db);
} else {
echo "Table created successfully\n";
}
pg_close($db);
?>