Postgres Pro
Downloads
Home   >   mailing lists

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

From Doug McNaught
Subject Re: Why are quotes required around table / column names in SQL statements?
Date
Msg-id m31yr455sr.fsf@belphigor.mcnaught.org
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
Tree view 
"Wade Burlingame" <bad@dog.bad> writes:

> ...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.

They're not required, unless you want to treat the table and column
names in a case-sensitive manner (which is not generally done).  The
SQL standard is case-insensitive I believe.

-Doug

pgsql-general by date:

Previous
From: Joel Burton
Date:
Subject: Re: Why are quotes required around table / column names in SQL statements?
Next
From: "Eric G. Miller"
Date:
Subject: Re: Arrays and COPY FROM: Help!!!