Pg2MySQL Converter Lightbox Technolgoies http://www.lightbox.org Author: James Grant INSTALLATION To use, simply unzip into your website somewhere, and point your browser at pg2mysql.php If you want to use your own interface, simply include the pg2mysql.inc.php into your own code and call the 'pg2mysql' function. It accepts one input (the postgres code to be converted) and returns the mysql code. eg: $mysql=pg2mysql($postgres); CHANGES VERSION 1.0 (I guess) - This is the first public release. Up until now it has been web-access only. - Allow "character varying" without a size. defaults to varchar(255) VERSION 1.1 - fix detection of field names that dont have `` around them when looking up a primary key VERSION 1.2 (Thanks to John Puster) - fix character varying 255 -> varchar(255) instead of text (<= vs <) - add conversions for 'time with(out) time zone' to 'time' field - correct 'timestamp with(out) time zone' to convert to 'timestamp' instead of 'datetime' and allow default CURRENT_TIMESTAMP