Re: creating table w/ php help - Mailing list pgsql-general

From Cornelia Boenigk
Subject Re: creating table w/ php help
Date
Msg-id 002a01c1e7ee$835e1ba0$aec1fea9@zwerg98
Whole thread Raw
In response to Re: creating table w/ php help  (David A Dickson <davidd@saraswati.wcg.mcgill.ca>)
List pgsql-general
> $query = "CREATE table $tablename (id INT UNSIGNED NOT NULL
> AUTO_INCREMENT PRIMARY KEY, ip TEXT, customer TEXT, dslphone TEXT,
date
> TEXT, vpivci TEXT)";

AUTO_INCREMENT is used in MySQL. With PostgreSQL you should use the
keyword SERIAL. Also UNSIGNED is not used.

> Here is the second problem. By looking at the php manual for the
pg-exec
> function (changed to pg-query in php 4)
It *will* change from PHP 4.2.0 on. pg_exec() is still valid for all
releases < 4.2.0.

Regards
Conni


pgsql-general by date:

Previous
From: Doug McNaught
Date:
Subject: Re: Building perl mods pg:PG or DBD:PG on non
Next
From: Alex Krohn
Date:
Subject: Re: unable to repair table: missing chunk number