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

From: Doug McNaught <doug(at)wireboard(dot)com>
To: mikey(dot)unsafe(at)gmx(dot)net (Mikey)
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: SQL: Are the "" around table & coloumnames necessary?
Date: 2002-02-21 21:33:22
Message-ID: m3lmdm7c65.fsf@varsoon.denali.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

mikey(dot)unsafe(at)gmx(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Pam Wampler 2002-02-21 21:36:19 Re: copy notice
Previous Message Jeff Eckermann 2002-02-21 21:31:57 Re: copy notice