postgresql error: parser

Anon

Can anyone explain to me what the following error means:
Error parser: parse error at or near "friend_id"

I typed the following code:
create table friend_info (friend_id char(5), full_name char(100), birth_date date, fav_color char(25), unique friend_id(friend_id));

Please help!

pnoeric

Hi Randall, looks like you have the syntax wrong on the UNIQUE statement... try this:

CREATE TABLE "friend_info" (
"friend_id" char (5) NOT NULL,
"full_name" char (100) NOT NULL,
"birth_date" date NOT NULL,
"fav_color" char (25) NOT NULL,
UNIQUE ("friend_id"));

Anon

Hi. I am having an error and I don't know what's wrong with the code. The code is:

while($row=pg_fetch_array($sql_result)) {
//this is line 14

$full_name=$rwo["Full_Name"];
$birth_date=$row["Birth_date"];
$fave_color=$row["Fave_color"];

I am getting the following warning:
warning: wrong parameter count for pg_fetch_array() in /home/httpd/html/randall/firstdb.php3 on line 14

Anon

I'm trying to create tables on a (supposedly) properly-configured web server using PHP 4.1.1. My code looks like this:

<?PHP

CREATE TABLE inventory (
vin varchar(25),
color varchar(10),
damage varchar(10));

?>
I left out the connection stuff (that part is working ok).
When I bring up the page, I get a parser error message that points to the CREATE TABLE
line. I've tested the syntax of the SQL statement so I know that's not the problem.
I haven't found anywhere that tells me how to create tables or issue this type of sql command from within a PHP script. Any help would be appreciated.