Re: Porting from MySql - meta data issues - Mailing list pgsql-general

From Jean-Michel POURE
Subject Re: Porting from MySql - meta data issues
Date
Msg-id 200204090832.23750.jm.poure@freesurf.fr
Whole thread Raw
In response to Porting from MySql - meta data issues  (Geoff Caplan <geoff@advantae.com>)
List pgsql-general
> 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

pgsql-general by date:

Previous
From: Ed Loehr
Date:
Subject: Re: Hash Join vs Nested Loops in 7.2.1 ...
Next
From: Mark kirkwood
Date:
Subject: Re: [HACKERS] Re : Solaris Performance - Profiling