On 09/07/11 1:45 PM, Arun Nadar wrote:
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.
String sql="SELECT \"Id\", \"Name\" FROM \"Student\" ORDER BY \"Id\"";
Alternately, create your table with all lower case names, and you won't
have this problem.
alter table "Student" rename to student;
alter table student rename column "Id" to id;
alter table student rename column "Name" to name;
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
