X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B2C7D5E37D0 for ; Mon, 16 Aug 2004 14:32:04 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 80975-07 for ; Mon, 16 Aug 2004 17:31:54 +0000 (GMT) Received: from hosting.planetargon.com (hosting.planetargon.com [69.44.62.20]) by svr1.postgresql.org (Postfix) with SMTP id 5B24A5E3639 for ; Mon, 16 Aug 2004 14:31:52 -0300 (ADT) Received: (qmail 3571 invoked by uid 510); 16 Aug 2004 17:31:20 -0000 Received: from unknown (HELO ?192.168.1.101?) (robby@planetargon.com@67.160.164.97) by hosting.planetargon.com with SMTP; 16 Aug 2004 17:31:20 -0000 Subject: Re: How to create a new Table in prostgresql from a From: Robby Russell To: Michelle Konzack Cc: pgsql-php@postgresql.org In-Reply-To: <20040816171128.GD25345@freenet.de> References: <20040814151530.GC28829@freenet.de> <20040816171128.GD25345@freenet.de> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-IBGYk7IyAYoqU5p3VDjg" Organization: PLANET ARGON Message-Id: <1092677505.19357.15.camel@vacant> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Mon, 16 Aug 2004 10:31:45 -0700 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200408/27 X-Sequence-Number: 2915 --=-IBGYk7IyAYoqU5p3VDjg Content-Type: text/plain Content-Transfer-Encoding: quoted-printable On Mon, 2004-08-16 at 10:11, Michelle Konzack wrote: > Am 2004-08-15 00:55:34, schrieb Raoul Buzziol: > > Michelle Konzack wrote: > >=20 > > > Hello, > > >=20 > > > Never I have done this before (no need) but now I nee to create a > > > new table with some colums from a Webinterface and do not know how > > > to do that. > >=20 > > You have to execute a query: > >=20 > > pg_query(connection, "CREATE TABLE tablename (id serial, val int4...);"= ); >=20 > :-/ >=20 > I was looking for a php-Command or somthing like this to create the=20 > table but not thinking on a pg_query WHICH execute the command... >=20 Well, a CREATE TABLE is just another type of SQL Query that you can run. It's not a 'command' exactly..just a query. -Robby --=20 /*************************************** * Robby Russell | Owner.Developer.Geek * PLANET ARGON | www.planetargon.com * Portland, OR | robby@planetargon.com * 503.351.4730 | blog.planetargon.com * PHP/PostgreSQL Hosting & Development ****************************************/ --=-IBGYk7IyAYoqU5p3VDjg Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.5 (GNU/Linux) iD8DBQBBIO+B0QaQZBaqXgwRAq6SAKDBBPumsZSF700SWcOB9Eca9NSZdQCgq6mI 9TqemdkAdFxh5M1+etzToRQ= =U2JC -----END PGP SIGNATURE----- --=-IBGYk7IyAYoqU5p3VDjg--