> I'm porting quite a big PHP application from MySql and have hit an issue.
Maybe you should use pgAdmin2 (http://pgadmin.postgresql.org), PostgreSQL
Windows GUI, which offers several advanced features :
- access to all PostgreSQL objects (tables, views, triggers, rules, functions,
indexes, etc...),
- code editor with syntax highlight (SQL, PLpgSQL, PLperl, PLpython, etc...).
- function modification, pseudo modification of views and triggers,
- data migration wizard.
With pgAdmin2, it should be easy to port your PHP code to PLpgSQL. Maybe you
should start with writing views and add PLpgSQL then.
Cheers,
Jean-Michel