mySQL to postgreSQL: Request for pointers to perl/php resources for app conversion.

[Sanjay Arora]

Hi All

Am looking for pointers to resouces that compare database naming, sql differences between mySQL & postgreSQL, for building a checklist for converting existing perl/php applications from mySQL to postgreSQL.

Please advise.

With regards.
Sanjay.



---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

[Andrew Hammond]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Sanjay Arora wrote:
| Hi All
|
| Am looking for pointers to resouces that compare database naming, sql
differences
| between mySQL & postgreSQL, for building a checklist for converting
existing
| perl/php applications from mySQL to postgreSQL.

I don't know of any checklist, but you should definately look at the
MySQL gotchas page.

http://sql-info.de/mysql/gotchas.html

- --
Andrew Hammond 416-673-4138 ***@ca.afilias.info
Database Administrator, Afilias Canada Corp.
CB83 2838 4B67 D40F D086 3568 81FC E7E5 27AF 4A9A
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)

iD8DBQFBKgdwgfzn5SevSpoRAvOBAKCwGNoLRvufmQlzXVK0txbnXxpAeQCgrkFF
nY6xFDl7QkRwZ5mGmR1tYvU=
=CJmZ
-----END PGP SIGNATURE-----

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ***@postgresql.org