Postgres Pro
Downloads
Home   >   mailing lists

Re: case sensitivity for tables, columns, and constraint names - Mailing list pgsql-sql

From Andrew Sullivan
Subject Re: case sensitivity for tables, columns, and constraint names
Date
Msg-id 20071211173037.GL27409@crankycanuck.ca
Whole thread Raw
In response to case sensitivity for tables, columns, and constraint names  ("Ertel, Steve" <Steve.Ertel@infimatic.com>)
List pgsql-sql
Tree view 
On Tue, Dec 11, 2007 at 11:05:25AM -0600, Ertel, Steve wrote:

> 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, sorry.  The always-one-case rule for unquoted identifiers is ANSI
conformant.  As it happens, the ANSI rule also makes everything ALLCAPS, but
PostgreSQL doesn't go that way (for historical reasons).

A

pgsql-sql by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: case sensitivity for tables, columns, and constraint names
Next
From: Richard Huxton
Date:
Subject: Re: case sensitivity for tables, columns, and constraint names