Le Mardi 14 Mai 2002 09:43, Samuele Brignoli a écrit :
> Do you know if exists a tool that automagically generate stored procedures
> for an existing postgresql's table ? Maybe for insert, delete, update, this
> basic things.
Presently, pAdmin2 is not an 'automatic' code generator. pgAdmin2 allows
adding, modifying and dropping triggers. Each trigger is linked to a
PostgreSQL server-side function and to a table. Functions can be written in
several languages : PLpgSQL, PLperl, PLpython, PLtk and soon PLjava...
This is one of several advanced PostgreSQL features. The only thing is that
your PostgreSQL server needs to be compiled with the required server-side
languages. In Linux, binaries are delivered with PLpgSQL built in and there
is an RPM for each other language.
To enable PLpgSQL server-side language :
postgres@localhost> createlang plpgsql database_name
Further information:
> PostgreSQL online doc :
http://www.postgresql.org/idocs/index.php?programmer-pl.html
> Example of downloading PostgreSQL binaries
Redhat :
http://www.rpmfind.net//linux/RPM/rawhide/1.0/i386/RedHat/RPMS/PByName.html
Mandrake :
http://www.rpmfind.net/linux/RPM/cooker/cooker/i586/Mandrake/RPMS/PByName.html
Have fun,
Cheers, Jean-Michel POURE
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster