How to create a new Table in prostgresql from a Webinterface

--RIYY1s2vRbPFwWeW
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

Hello,=20

Never I have done this before (no need) but now I nee to create a=20
new table with some colums from a Webinterface and do not know how=20
to do that.=20

Please can anyone point me into the right direction ?

Thanks, Greetings=20
and nice Weekend
Michelle

--=20
Linux-User #280138 with the Linux Counter, http://counter.li.org/=20
Michelle Konzack Apt. 917 ICQ #328449886
50, rue de Soultz MSM LinuxMichi
0033/3/88452356 67100 Strasbourg/France IRC #Debian (irc.icq.com)

--RIYY1s2vRbPFwWeW
Content-Type: application/pgp-signature; name="signature.pgp"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFBHiyRC0FPBMSS+BIRAiGnAKCSMB909iCw7g0mugEK+1gGiEyPswCe OK0a
7QsopQ+zQvWWK7/ExDVkNfU=
=UO9t
-----END PGP SIGNATURE-----

--RIYY1s2vRbPFwWeW--

Re: How to create a new Table in prostgresql from a Webinterface

Michelle Konzack wrote:

> Hello,
>
> 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.

You have to execute a query:

pg_query(connection, "CREATE TABLE tablename (id serial, val int4...);");


>
> Please can anyone point me into the right direction ?
>
> Thanks, Greetings
> and nice Weekend
> Michelle
>


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Re: How to create a new Table in prostgresql from a

--=-P7Ziq5bpi5UDBoDgZls0
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

On Sat, 2004-08-14 at 17:15 +0200, Michelle Konzack wrote:
> Hello,
>
> 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.
>
> Please can anyone point me into the right direction ?

Are you looking for something like this? I just knocked this out, so
I'm sure ther are syntax errors and whatnot, but it should give you an
idea.

Oh, and are mime attachments considered OK on this list? If not, my
apologies.

-Steve

--=-P7Ziq5bpi5UDBoDgZls0
Content-Disposition: attachment; filename=create_table.php
Content-Type: application/x-php; name=create_table.php
Content-Transfer-Encoding: 7bit


// create_table.php

// Creates a table based on variables fieldname1, type1 and fieldname2, type2

$fieldname1 = $_POST['fieldname1'];
$type1 = $_POST['type1'];
$fieldname2 = $_POST['fieldname2'];
$type2 = $_POST['type2'];

$PGCON = pg_connect(dbname="mydb" user="me" password="mypassword");

$query_string = "DROP TABLE demo";

pg_query($PGCON,$query_string);

$query_string = <<
CREATE TABLE demo (
$fieldname1 $type1,
$fieldname2 $type2
)

EOT;

pg_query($PGCON,$query_string);

pg_close($PGCON);

?>

--=-P7Ziq5bpi5UDBoDgZls0
Content-Disposition: attachment; filename=webform.php
Content-Type: application/x-php; name=webform.php
Content-Transfer-Encoding: 7bit


// webform.php

// Web interface form


$pageStr = "";
$pageStr .= <<

Re: How to create a new Table in prostgresql from a Webinterface

--XOIedfhf+7KOe/yw
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

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...);");

:-/

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...


Greetings
Michelle

--=20
Linux-User #280138 with the Linux Counter, http://counter.li.org/=20
Michelle Konzack Apt. 917 ICQ #328449886
50, rue de Soultz MSM LinuxMichi
0033/3/88452356 67100 Strasbourg/France IRC #Debian (irc.icq.com)

--XOIedfhf+7KOe/yw
Content-Type: application/pgp-signature; name="signature.pgp"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFBIOq/C0FPBMSS+BIRArUwAKC53+bu5VxJ/wTV0TvQTCOOc6xYIwCd F/dk
NxZiAtYnMrviQ0Xqdg46l7Y=
=ffLx
-----END PGP SIGNATURE-----

--XOIedfhf+7KOe/yw--

Re: How to create a new Table in prostgresql from a

--=-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+B0QaQZBaqXgwRAq6SAKDBBPumsZSF700SWcOB9Eca9NSZdQCg q6mI
9TqemdkAdFxh5M1+etzToRQ=
=U2JC
-----END PGP SIGNATURE-----

--=-IBGYk7IyAYoqU5p3VDjg--

Re: How to create a new Table in prostgresql from a Webinterface

On php.net, if you did a search for pg_ , you would have seen the PHP
Function List .....

pg_close pg_connect pg_convert pg_copy_to
pg_dbname pg_delete pg_get_pid pg_host
pg_insert pg_lo_open pg_lo_read pg_lo_seek
pg_ping pg_port pg_query pg_select
pg_trace pg_tty pg_update preg_grep


\\pb

Michelle Konzack wrote:
> Am 2004-08-15 00:55:34, schrieb Raoul Buzziol:
>
>>Michelle Konzack wrote:
>>
>>
>>>Hello,
>>>
>>>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.
>>
>>You have to execute a query:
>>
>>pg_query(connection, "CREATE TABLE tablename (id serial, val int4...);");
>
>
> :-/
>
> I was looking for a php-Command or somthing like this to create the
> table but not thinking on a pg_query WHICH execute the command...
>
>
> Greetings
> Michelle
>

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Re: How to create a new Table in prostgresql from a Webinterface

Just a followup question.

I'm fairly new to using PHP and pg. Security wise how could I limit a request such as
this? I'm assuming that if you have given a PHP user the ability to create tables, the
user also has the ability to truncate and delete tables as well.

> On php.net, if you did a search for pg_ , you would have seen the PHP
> Function List .....
>
> pg_close pg_connect pg_convert pg_copy_to
> pg_dbname pg_delete pg_get_pid pg_host
> pg_insert pg_lo_open pg_lo_read pg_lo_seek
> pg_ping pg_port pg_query pg_select
> pg_trace pg_tty pg_update preg_grep
>
>
> \\pb
>
> Michelle Konzack wrote:
> > Am 2004-08-15 00:55:34, schrieb Raoul Buzziol:
> >
> >>Michelle Konzack wrote:
> >>
> >>
> >>>Hello,
> >>>
> >>>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.
> >>
> >>You have to execute a query:
> >>
> >>pg_query(connection, "CREATE TABLE tablename (id serial, val int4...);");
> >
> >
> > :-/
> >
> > I was looking for a php-Command or somthing like this to create the
> > table but not thinking on a pg_query WHICH execute the command...
> >
> >
> > Greetings
> > Michelle
> >
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

Re: How to create a new Table in prostgresql from a Webinterface

>>pg_query(connection, "CREATE TABLE tablename (id serial, val int4...);");
>
>
> :-/
>
> I was looking for a php-Command or somthing like this to create the
> table but not thinking on a pg_query WHICH execute the command...

There is no such command.


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Re: How to create a new Table in prostgresql from a

T24gTW9uLCAxNiBBdWcgMjAwNCAxOTo0MToxNyAtMDUwMCAiVG9kZCBMZXdp
cyIgPGxld2lzLXRvZGRAY29tY2FzdC5uZXQ+IHNhdA0KZG93biwgdGhvdWdo
dCBsb25nIGFuZCB0aGVuIHdyb3RlOg0KDQo+IEp1c3QgYSBmb2xsb3d1cCBx
dWVzdGlvbi4NCj4gDQo+IEknbSBmYWlybHkgbmV3IHRvIHVzaW5nIFBIUCBh
bmQgcGcuIFNlY3VyaXR5IHdpc2UgaG93IGNvdWxkIEkgbGltaXQgYSByZXF1
ZXN0DQo+IHN1Y2ggYXMgdGhpcz8gSSdtIGFzc3VtaW5nIHRoYXQgaWYgeW91
IGhhdmUgZ2l2ZW4gYSBQSFAgdXNlciB0aGUgYWJpbGl0eSB0bw0KPiBjcmVh
dGUgdGFibGVzLCB0aGUgdXNlciBhbHNvIGhhcyB0aGUgYWJpbGl0eSB0byB0
cnVuY2F0ZSBhbmQgZGVsZXRlIHRhYmxlcyBhcw0KPiB3ZWxsLiANCj4gDQoN
CkEgZGF0YWJhc2UgdXNlciBoYXMgbm90IG11Y2ggaW4gY29tbW9uIHdpdGgg
YSBQSFAgdXNlciAob3IgYSBVTklYLSBvciBvdGhlcg0Kc3lzdGVtIHVzZXIp
LiBUaGUgdGFibGVzIHdpbGwgYmUgY3JlYXRlZCB3aXRoIHRoZSBkYXRhYmFz
ZSB1c2VyIHlvdSBoYXZlDQpjb25uZWN0ZWQgd2l0aCAoaWYgeW91IHVzZSBh
dXRoZW50aWNhdGlvbiBvdGhlciB0aGFuIHRydXN0IG9yIGlkZW50LCBzZWUN
CnBnX2hiYS5jb25mIGZvciBkZXRhaWxzKS4NCg0KU28gaWYgeW91IGNyZWF0
ZSB0YWJsZXMgd2l0aGluIFBIUCwgeW91IGNyZWF0ZSB0aGVtIGFzIHRoZSBj
b25uZWN0aW5nIGRhdGFiYXNlDQp1c2VyLCBhbmQgb2YgY291cnNlIHRoZSBj
cmVhdG9yIG1heSBkZXN0cm95IHRoZW0gYXMgd2VsbC4NCg0KQnV0IGlmIHlv
dSBoYXZlIGEgZGF0YWJhc2UsIGluIHdoaWNoIHRoZSB0YWJsZXMgYXJlIG93
bmVkIGJ5IHVzZXIgQSBhbmQgeW91DQpjb25uZWN0IHdpdGggdXNlciBCLCB1
c2VyIEIgbWF5IGNyZWF0ZSB0YWJsZXMgb3duZWQgYnkgaGltc2VsZiwgYnV0
IHVzdWFsbHkgbWF5DQpub3QgZHJvcCB0YWJsZXMgb3duZWQgYnkgdXNlciBB
LCBpZiBoZSBoYXMgbm90IGV4cGxpY2l0bHkgYmVlbiBncmFudGVkIHNvLg0K
DQpXaGF0IEkgZG8gaXM6IEkgaGF2ZSBhIGRhdGFiYXNlLCBpbiB3aGljaCBh
bGwgdGFibGVzIGFyZSBvd25lZCBieSB1c2VyIEEgKGENCnN1cGVydXNlcikg
YW5kIHVzZXIgQiAodGhlIFBIUCBjb25uZWN0aW5nIHVzZXIpIGhhcyB0aGUg
cmlnaHQgdG8gcmVhZCwgd3JpdGUsDQp1cGRhdGUgdGhlIHRhYmxlcywgc28g
aGUgY2FuIHdvcmsgd2l0aCB0aGVtLiBCdXQgdXNlciBCIGlzIG5vdCBhYmxl
IHRvIGRyb3AgYQ0KdGFibGUgb2YgdXNlciBBLiBVc2VyIEIsIGhvd2V2ZXIs
IGlzIGFsbG93ZWQgdG8gY3JlYXRlIGFuZCBkcm9wIGhpcyBvd24gdGFibGVz
LA0KaWYgaGUgbGlrZXMuIA0KDQpJZiB5b3UgY29ubmVjdCBldmVyeSBQSFAg
dXNlciBhcyBhIGRpZmZlcmVudCBkYXRhYmFzZSB1c2VyLCBubyBkYXRhYmFz
ZSB1c2VyIGlzDQphYmxlIChpZiBub3QgZXhwbGljaXRseSBncmFudGVkKSB0
byBkcm9wIG90aGVyIHVzZXJztCB0YWJsZXMuIElmIG5vdCBncmFudGVkIHNv
LA0KaGUgaXMgbm90IGV2ZW4gYWJsZSB0byB0b3VjaCB0aGVtIChoZSBjb3Vs
ZCBzZWUgdGhlaXIgZXhpc3RlbmNlLCBob3dldmVyKS4NCg0KUmVnYXJkcywN
Ci0tIA0KRnJhbmsgRmlubmVyDQoNCk1lbW9yeSBmb2xsb3dzIG1lbW9yeSwg
bWVtb3J5IGRlZmVhdHMgbWVtb3J5OyBzb21lIHRoaW5ncyBhcmUgYmFuaXNo
ZWQNCm9ubHkgaW50byB0aGUgcmVhbG1zIG9mIG91ciByaWNoIGltYWdpbmlu
Z3MgIC0gIGJ1dCB0aGlzIGRvZXMgbm90IG1lYW4NCnRoYXQgdGhleSBkbyBu
b3Qgb3IgY2Fubm90IG9yIHdpbGwgbm90IGV4aXN0IC0gdGhleSBleGlzdCEg
VGhleSBleGlzdCENCiAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIChN
LiBNb29yY29jaywgIlRoZSBSZXZlbmdlIE9mIFRoZSBSb3NlIikNCgotLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0oZW5kIG9mIGJyb2FkY2FzdCktLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0KVElQIDM6IGlmIHBvc3RpbmcvcmVh
ZGluZyB0aHJvdWdoIFVzZW5ldCwgcGxlYXNlIHNlbmQgYW4gYXBwcm9wcmlh
dGUKICAgICAgc3Vic2NyaWJlLW5vbWFpbCBjb21tYW5kIHRvIG1ham9yZG9t
b0Bwb3N0Z3Jlc3FsLm9yZyBzbyB0aGF0IHlvdXIKICAgICAgbWVzc2FnZSBj
YW4gZ2V0IHRocm91Z2ggdG8gdGhlIG1haWxpbmcgbGlzdCBjbGVhbmx5Cg==