Hi
I am currently using 'PostgreSQL 9.0.4' database with JDBC driver 'postgresql-9.0-801.jdbc4'. In my Java program normal SELECT query didn't work. ie, try { Class.forName("org.postgresql.Driver"); connection = DriverManager.getConnection("jdbc:postgresql://localhost/Student","postgres","postgres"); statement = connection.createStatement(); String sql="SELECT Id, Name FROM Student ORDER BY Id"; // problem resultSet = statement.executeQuery(sql); if(resultSet.next()) { String id=resultSet.getString(1); String name=resultSet.getString(2); } } catch (Exception e) { e.printStackTrace(); } finally { try { connection.close(); } catch (Exception e) { e.printStackTrace(); } } I directly write a query via pgAdmin III the above SELECT query didn't work { SELECT Id, Name FROM Student ORDER BY Id; } but it work by putting " ", like this SELECT "Id", "Name" FROM "Student" ORDER BY "Id"; in java String, inside of double inverted commas another is does not possible. how this code is implement through java program. please kindly send me the solution for this. Thanks & Regards Arun.R.T