Changes that will need to be made to support PostgreSQL:

$Id$
################################################################################

- All integers need to have their length dropped: int(20) goes to int
- Small integers int(2) et alter should be changed to smallint
- Cannot use REPLACE INTO x; need to delete records first or use UPDATE
- mediumtext needs to be converted to text
- Column renames need to be DB-specific. MySQL uses "ALTER TABLE x CHANGE y(def) TO z(def)" and PGSQL uses "ALTER TABLE x RENAME COLUMN y TO z"
- Joins need to be explicit "(INNER|LEFT|RIGHT) JOIN" instead of "WHERE x.a = y.a"
- AUTO_INCREMENT needs to be DB-specific switched to SERIAL without any integral information, but with primary-unique constraints
- Need change limiting agent from "LIMIT offset,max" and PGSQL uses "LIMIT max OFFSET offset"
- Fulltext searching is not supported in PGSQL, will need to rewrite searches to allow for some degree of niceness
- Need DB-specific DB->insert_id() for MySQL and DB->insert_id(table, column) for PGSQL
- FIND_IN_SET(find, field) needs to be "find = ANY(STRING_TO_ARRAY(field, ','))"
- Blobs need to become bytea fields; when inserting into them, pg_escape_bytea() needs to be run and when outputting it pg_unescape_bytea() needs to be run on the output