Re: Porting from MySql - meta data issues

From: Jean-Michel POURE <jm(dot)poure(at)freesurf(dot)fr>
To: Geoff Caplan <geoff(at)advantae(dot)com>
Cc: Postgres General List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Porting from MySql - meta data issues
Date: 2002-04-09 06:32:23
Message-ID: 200204090832.23750.jm.poure@freesurf.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mark kirkwood 2002-04-09 08:37:12 Re: [HACKERS] Re : Solaris Performance - Profiling
Previous Message Thomas Lockhart 2002-04-09 06:22:53 Re: [GENERAL] now() AT TIME ZONE 'GMT';