Re: Stored Procedures Generator

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(at)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