1
edit
Changes
→2- Modifying Syntax
:: 2- STORAGE ENGINE: In MySQL, the storage engine is set to a transactional safe engine such as [http://www.wikivs.com/wiki/MySQL_vs_PostgreSQL#MySQL:InnoDB InnoDB], whereas PostgreSQL has a single built in engine. So, implementation of <code> appendTableSuffix() </code> in PostgreSQLManager.java was removed
:: 3- CHARACTER SET: In MySQL, the character set should be defined when creating a table. Whereas in PostgreSQL when a database is created, the character set is set to 'UTF8' by default.
:: 4- AUTO INCREMENT:[http://pointbeing.net/weblog/2008/03/mysql-versus-postgresql-adding-an-auto-increment-column-to-a-table.html]
::
<source lang=java>
<source lang=java>
/* PostgreSQL version of creating table script */
id integer not null, s text null, bin bytea null,
n integer null, n1 smallint null, l bigint null, "DEC" decimal(10,5) null,
constraint RangeTest_PK primary key(id)
);
CREATE SEQUENCE test.RangeTest_id_seq;
ALTER TABLE test.RangeTest ALTER COLUMN id SET DEFAULT NEXTVAL('test.RangeTest_id_seq');
</source>