Date: Fri, 9 Mar 2007 09:21:03 -0500
From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-sql@postgresql.org
Subject: Re: CREATE TABLE
Message-ID: <20070309142103.GB24287@phlogiston.dyndns.org>
References: <00ed01c76252$b0bc28b0$1102a8c0@dream>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <00ed01c76252$b0bc28b0$1102a8c0@dream>
User-Agent: Mutt/1.5.9i

On Fri, Mar 09, 2007 at 02:56:06PM +0100, Shavonne Marietta Wijesinghe wrote:
> 
> But the problem i have is that when i go and open my database in
> pgadmin the table name and coloumn name is written in lowercase :(

Unquoted identifiers in PostgreSQL are folded to lower case.  This is
contrary to the SQL spec, but it normally doesn't matter because the
rule is applied consistently.

Therefore, you have two possibilities:

1.	_Never_ quote identifiers.  If you do it this way, everything
will always be folded to lower case, so your queries will always work
correctly.

2.	_Always_ quote identifiers.  This way, you always get upper
case, or mixed case, or lower case, or whatever.  Indeed, you can
actually have two tables named "mytable" and "MyTable" this way, if
you were so inclined/completely mad.  

The important thing to remember is that you have to pick one style,
and be absolutely certain to use it consistently.  If you mix the
styles, you'll get surprises.

A
-- 
Andrew Sullivan  | ajs@crankycanuck.ca
The whole tendency of modern prose is away from concreteness.
		--George Orwell