HDBC driver interface for PostgreSQL 8.x

Written by John Goerzen, [email protected]

NOTE ON DATES AND TIMES

The recommended correspondence between PostgreSQL date and time types and HDBC SqlValue types is:

• SqlLocalDate: DATE
• SqlLocalTimeOfDay: TIME WITHOUT TIME ZONE
• SqlZonedLocalTimeOfDay: TIME WITH TIME ZONE
• SqlLocalTime: TIMESTAMP WITHOUT TIME ZONE
• SqlZonedTime: TIMESTAMP WITH TIME ZONE
• SqlUTCTime: TIMESTAMP WITH TIME ZONE
• SqlDiffTime: INTERVAL
• SqlPOSIXTime: NUMERIC
• SqlEpochTime: INTEGER
• SqlTimeDiff: INTERVAL

Other combinations are possible, and may even be converted automatically. The above simply represents the types that seem the most logical correspondence, and thus are tested by the HDBC-PostgreSQL test suite.

Connect to a PostgreSQL server.

See http://www.postgresql.org/docs/8.1/static/libpq.html#LIBPQ-CONNECT for the meaning of the connection string.