Re: SQL: Are the "" around table & coloumnames necessary? - Mailing list pgsql-general

From Doug McNaught
Subject Re: SQL: Are the "" around table & coloumnames necessary?
Date
Msg-id m3lmdm7c65.fsf@varsoon.denali.to
Whole thread Raw
In response to SQL: Are the "" around table & coloumnames necessary?  (mikey.unsafe@gmx.net (Mikey))
List pgsql-general
mikey.unsafe@gmx.net (Mikey) writes:

> 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 "" ?

Double-quotes should only be necessary if your table names are
MixedCase.

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
   --T. J. Jackson, 1863

pgsql-general by date:

Previous
From: Jeff Eckermann
Date:
Subject: Re: copy notice
Next
From: Pam Wampler
Date:
Subject: Re: copy notice