适用于jdk7的pstgresql for JDBC驱动,本人在greenplum中测试通过,集成在c3p0中也可,properties写法参照:
jdbc.driverClass = org.postgresql.Driver
jdbc.jdbcUrl = jdbc:postgresql://yourip/dbname?currentSchema=yourschema
jdbc.username = yourusername
jdbc.password = yourusername
如果还有hibernate的话:
hibernate.dialect = org.hibernate.dialect.PostgreSQLDialect