What is the most suitable hibernate.dialect for postgresql 10.5?

Question

I am looking at hibernate documentation here: https://docs.jboss.org/hibernate/orm/5.0/javadocs/org/hibernate/dialect/package-summary.html to try to find which hibernate.dialect to use inside persistence.xml

It does not mention a class for Postgres 10.x. Should I use PostgreSQL94Dialect?

And what do you think of this class that is allegedly for `An SQL dialect for Postgres 9.4 and later.` ... do you think that covers Postgres 10.x? Is 10.x later than 9.4? Clearly other JPA providers just autodetect the database and dont rely on users to have to set such things ... — , Oct 18 '18 at 10:23
Hibernate 5.4 has [PostgreSQL10Dialect](http://docs.jboss.org/hibernate/orm/5.4/javadocs/org/hibernate/dialect/PostgreSQL10Dialect.html) — tianyeblack, May 08 '19 at 23:52

score 20 · Answer 1 · answered Nov 23 '18 at 15:06

20

Looking at newest documentation and it's PostgreSQL95Dialect

answered Nov 23 '18 at 15:06

1 Answers1