Re: Case sensitivity question . . .

From: "Gregory Wood" <gregw(at)com-stock(dot)com>
To: "Peter E(dot) Chen" <pchen3(at)jhmi(dot)edu>
Cc: "PostgreSQL-General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Case sensitivity question . . .
Date: 2002-01-02 21:00:12
Message-ID: 001301c193d1$a4e1bd70$7889ffcc@comstock.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

http://www7.us.postgresql.org/users-lounge/docs/7.1/user/sql-syntax.html#SQL
-SYNTAX-IDENTIFIERS

----- Excerpt -----
There is a second kind of identifier: the delimited identifier or quoted
identifier. It is formed by enclosing an arbitrary sequence of characters in
double-quotes ("). A delimited identifier is always an identifier, never a
key word. So "select" could be used to refer to a column or table named
"select", whereas an unquoted select would be taken as a key word and would
therefore provoke a parse error when used where a table or column name is
expected. The example can be written with quoted identifiers like this:

UPDATE "my_table" SET "a" = 5;

Quoted identifiers can contain any character other than a double quote
itself. This allows constructing table or column names that would otherwise
not be possible, such as ones containing spaces or ampersands. The length
limitation still applies.

Quoting an identifier also makes it case-sensitive, whereas unquoted names
are always folded to lower case. For example, the identifiers FOO, foo and
"foo" are considered the same by Postgres, but "Foo" and "FOO" are different
from these three and each other. [1]
----------

That being said, I wouldn't do it unless you really need it.

Greg

----- Original Message -----
From: "Peter E. Chen" <pchen3(at)jhmi(dot)edu>
To: "Postgres (General)" <pgsql-general(at)postgresql(dot)org>
Sent: Wednesday, January 02, 2002 3:21 PM
Subject: [GENERAL] Case sensitivity question . . .

> Hey All,
>
> I'm trying to create new databases and tables. The database names and
> tables always end up in lower case. Is there a way to have some upper
case
> letters in database and table names?
>
> Thanks for any help.
>
> Peter
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Doug McNaught 2002-01-02 21:06:00 Re: Case sensitivity question . . .
Previous Message Peter E. Chen 2002-01-02 20:43:07 Question on populating tables . . .