Re: CREATE TABLE - Mailing list pgsql-sql

From Bart Degryse
Subject Re: CREATE TABLE
Date
Msg-id 45F17F21.A3DD.0030.0@indicator.be
Whole thread Raw
In response to Re: CREATE TABLE  (Andrew Sullivan <ajs@crankycanuck.ca>)
List pgsql-sql
Because being consistent is easily overlooked I would advise not to quote the table names
Instead of calling your table thisTableIsBig call it this_table_is_big
 

>>> Andrew Sullivan <ajs@crankycanuck.ca> 2007-03-09 15:21 >>>
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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@postgresql.org so that your
       message can get through to the mailing list cleanly

pgsql-sql by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: Fw: CREATE TABLE
Next
From: Gerardo Herzig
Date:
Subject: index not being used. Why?