Re: creating table w/ php help

From: "Cornelia Boenigk" <poppcorn(at)cornelia-boenigk(dot)de>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: creating table w/ php help
Date: 2002-04-19 22:05:55
Message-ID: 002a01c1e7ee$835e1ba0$aec1fea9@zwerg98
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alex Krohn 2002-04-19 22:12:56 Re: unable to repair table: missing chunk number
Previous Message Doug McNaught 2002-04-19 21:43:49 Re: Building perl mods pg:PG or DBD:PG on non