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

From: missive(at)frontiernet(dot)net (Lee Harr)
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Why are quotes required around table / column names in SQL statements?
Date: 2001-04-03 01:25:45
Message-ID: 9ab8qp$ivo$1@node17.cwnet.frontiernet.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 02 Apr 2001 08:56:16 GMT, Wade Burlingame <bad(at)dog(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-04-03 01:37:40 Re: compile error
Previous Message Soma Interesting 2001-04-03 00:44:56 Re: compile error