Differences between H2SQL and PostgreSQL

[Stefan Albracht]

Hi,

for a project I need to know the syntactical differences between H2SQL and PostgreSQL. Has somebody already done this? 

Note: I am not planing to simply convert databases from this to that, so something like Flywaydb is not what I am looking for...

Thanks,

Stefan

[Thomas Mueller]

Hi,

I'm afraid there is no simple comparison table.

The H2 SQL grammar is documented at http://h2database.com/html/grammar.html

The PostgreSQL grammar is documented at http://www.postgresql.org/docs/8.1/static/sql.html

Regards,

Thomas

--
You received this message because you are subscribed to the Google Groups "H2 Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email to h2-database...@googlegroups.com.
To post to this group, send email to h2-da...@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.

[bjorndarri]

Hi,

You may want to look at http://jooq.org, I reviewed some of the source the other day
and I'm pretty sure you'll be able to find something of use in there.

/Björn Darri