The PostgreSQL driver is a complete implementation of both JDBC's and PostgreSQL's features.
The features include:
Connection
- Type2 driver connecting via libpq
- Type4 driver with 100% Java network code
- SSL support
- UnixDomainSocket support (with the Type2 driver and a JNI enabled Type4 driver)
- Asynchronous notification support (with the Type4 driver)
JDBC features
- CallableStatement support with getParameterMetaData
- PreparedStatement support with real getMetaData support
- BatchUpdate support (full functionality)
- DatabaseMetaData support
- getGeneratedKeys support for obtaining last inserted Oid value
PostgreSQL features
- setCatalog support to change to different catalogs
- full support for BLOB
- full support for bytea
- Array support
- SQLData, SQLInput, SQLOutput support for known composite types
- Binary cursored ResultSet support