Re: case sensitivity for tables, columns, and constraint names

From: Richard Huxton <dev(at)archonet(dot)com>
To: "Ertel, Steve" <Steve(dot)Ertel(at)infimatic(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: case sensitivity for tables, columns, and constraint names
Date: 2007-12-11 17:35:06
Message-ID: 475ECA4A.5060300@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Ertel, Steve wrote:
> I see that I can create a table with a mixed case name as long as the
> name is wrapped in quotes. Is there a setting to allow upper case
> and mixed case names for database tables, fields, etc, without having
> to wrap each in quotes?

No, SQL defines identifiers as case-insensitive.

PG is unusual in that left alone it folds names to lower-case rather
than upper, but all SQL databases (afaik) are case-insensitive by default.

--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Gerry Reno 2007-12-11 18:18:17 Re: join on three tables is slow
Previous Message Andrew Sullivan 2007-12-11 17:30:37 Re: case sensitivity for tables, columns, and constraint names