Re: Why are quotes required around table / column names in SQL statements?

From: Doug McNaught <doug(at)wireboard(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Why are quotes required around table / column names in SQL statements?
Date: 2001-04-08 05:17:24
Message-ID: m31yr455sr.fsf@belphigor.mcnaught.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Wade Burlingame" <bad(at)dog(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joel Burton 2001-04-08 05:31:36 Re: Why are quotes required around table / column names in SQL statements?
Previous Message Glenn 2001-04-08 05:11:36 How to cache database?