Re: SQL: Are the "" around table & coloumnames necessary?

Поиск
Список
Период
Сортировка
От Samik Raychauhduri
Тема Re: SQL: Are the "" around table & coloumnames necessary?
Дата
Msg-id 3C71B2C4.3050305@cae.wisc.edu
обсуждение исходный текст
Ответы Re: SQL: Are the "" around table & coloumnames necessary?
Список pgsql-general
Are you using psql or any other program interface to write queries? For
me the queries does work without quotes around column-names.
HTH. Regards.
-Samik

Mikey wrote:

> Hello,
>
> when I  write a select for example,
> it doesn't work this way:
>
>    select col1, col2
>       from my_table;
>
> instead of that I have to write
>
>    select "col1", "col2"
>       from "my_table";
>
> I dont understand this...is there a way to use
> the more comfortable form without "" ?
>
> thx
>
> ...Mike
>


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

Предыдущее
От: "Dr. Evil"
Дата:
Сообщение: Default timezones and Postgres
Следующее
От: Samik Raychaudhuri
Дата:
Сообщение: Selectively compile psql