Re: Why are quotes required around table / column names in SQL statements? - Mailing list pgsql-general

From missive@frontiernet.net (Lee Harr)
Subject Re: Why are quotes required around table / column names in SQL statements?
Date
Msg-id 9ab8qp$ivo$1@node17.cwnet.frontiernet.net
Whole thread Raw
In response to Why are quotes required around table / column names in SQL statements?  ("Wade Burlingame" <bad@dog.bad>)
List pgsql-general
On Mon, 02 Apr 2001 08:56:16 GMT, Wade Burlingame <bad@dog.bad> wrote:
>
>...and is there any way I can get rid of this requirement?  I'm just getting
>into PGSQL and I find the quotes very distracting.


I never use quotes on table or column names.

I think you only need them if you want to have capitalization
be significant to the name. Normally (with no quotes)
table == Table == TaBlE == TABLE

Quotes also allow you to use spaces in names.

Like I said, I never use this feature.

pgsql-general by date:

Previous
From: "Thomas F. O'Connell"
Date:
Subject: inheritance and foreign keys
Next
From: Bruce Momjian
Date:
Subject: Re: [DOCS] Better Features document?