I'm currently using Postgrseql 7.4.8 including the JDBC driver. I'm
considering moving up to version 8, and thinking about intermediate
steps.
- Can the 8.x driver be used with a 7.4.8 server?
- What are the major differences between the two versions? I checked
out the jdbc.postgresql.com changelog, but I'm looking for
higher-level information. I'm particularly interested in
performance-related improvements: use of server-side prepared
statements, string overhead in the driver, etc.
- Can COPY TO STDOUT and COPY FROM STDIN be done using the 8.x driver?
(I couldn't get these to work in 7.4.x).
Jack Orenstein