From: Richard Huxton <dev@archonet.com>
To: Ertel, Steve <Steve.Ertel@infimatic.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: case sensitivity for tables, columns, and constraint names
Date: Tue, 11 Dec 2007 17:35:06 +0000
Message-ID: <475ECA4A.5060300@archonet.com> (raw)
In-Reply-To: <863ECFDF04C8804ABDF3559D87F157C638E5D9@MAGPTCPEXC02.na.mag-ias.net>
References: <863ECFDF04C8804ABDF3559D87F157C638E5D9@MAGPTCPEXC02.na.mag-ias.net>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@archonet.com, Steve.Ertel@infimatic.com
Subject: Re: case sensitivity for tables, columns, and constraint names
In-Reply-To: <475ECA4A.5060300@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox