Re: Problem using PostgreSQL 9.0.4 with Java

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: Problem using PostgreSQL 9.0.4 with Java
Дата
Msg-id 4E67E3CF.2010908@hogranch.com
обсуждение исходный текст
Ответ на Problem using PostgreSQL 9.0.4 with Java  (Arun Nadar <arun_rt@rocketmail.com>)
Список pgsql-general
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


В списке pgsql-general по дате отправления:

Предыдущее
От: "Tomas Vondra"
Дата:
Сообщение: Re: Problem using PostgreSQL 9.0.4 with Java
Следующее
От: Chris Redekop
Дата:
Сообщение: Re: Demoting master to slave without an rsync...is it safe?