import java.sql.*;

class Test {
	public static void main (String argv[]) throws Exception {
		Class.forName("org.postgresql.Driver");
		Connection db = DriverManager.getConnection("jdbc:postgresql:testdb", "pei", "");

		Statement st;

		st = db.createStatement();
		ResultSet rs = st.executeQuery("SELECT * FROM testtimezone_target;");
		while (rs.next()) {
			System.out.print("Column 1 returned ");
			System.out.println(rs.getString(1));
			System.out.print("Column 2 returned as string ");
			System.out.println(rs.getString(2));
			System.out.print("Column 2 returned as timestamp ");
			System.out.println(rs.getTimestamp(2));
			System.out.print("Column 3 returned ");
			System.out.println(rs.getString(3));
		}
		rs.close();
		st.close();

		db.close();
	}
}