Re: [Treebase-devel] postgres case

[Hilmar L. <hl...@ne...>]

PostgreSQL is case-insensitive for table and column names, so it  
doesn't really matter which case you use.

It also shouldn't matter whether the Hibernate code and the schema DDL  
code use different case.

The convention for PostgreSQL schemas and SQL code is to use lower- 
case for tables and columns, but if doing so is work then it shouldn't  
be necessary to bother.

When I write SQL (whether DDL or queries) for PostgreSQL I typically  
use the convention of writing all SQL reserved words in all-caps  
whereas all tables, columns, and aliases are in all-lower. But that's  
only for increased readability - you can mix it wildly and it should  
still be syntactically correct.

	-hilmar

On Jun 15, 2009, at 3:50 PM, Rutger Vos wrote:

> Hi Hilmar,
>
> what would you recommend for the postgres schema: either change the
> case of all table names and column names to lower case (which seems to
> be more postgres-y) but then having to change the hibernate
> annotations or leave as is and be "weird" w.r.t. postgres practices?
>
> Rutger
>
>
>
> -- 
> Dr. Rutger A. Vos
> Department of zoology
> University of British Columbia
> http://www.nexml.org
> http://rutgervos.blogspot.com