• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: pgsql and case preservation
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: pgsql and case preservation


  • Subject: Re: pgsql and case preservation
  • From: "Jerry W. Walker" <email@hidden>
  • Date: Sun, 14 Mar 2004 22:42:29 -0500

A couple databases fail to honor or retain name case.

The typical approach is to use underbars in the table name, e.g.

  Entity name = ClientStorage
  Class name = ClientStorage
  Table name = CLIENT_STORAGE (or client_storage depending on the DB).

You'll find this approach used in most WO developers' EOModels.

Good luck.

Jerry

On Sunday, March 14, 2004, at 10:00 PM, Greg Hulands wrote:

Hi,
I have created an eomodel for postgres with table names like ClientStorage, but when I execute the sql, the table name turns into clientstorage. This happens with column names as well. I tried running the sql in phpPgAdmin and the same thing occured. Does anyone know how to get postgres to honor the case of table and column names?


Thanks,
Greg
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.




--
__ Jerry W. Walker
c o d e f a b - "High Performance Industrial Strength Internet Enabled Systems"
email@hidden
212 465 8484 X-102 office
212 465 9178 fax
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.



  • Prev by Date: Re: pgsql and case preservation
  • Next by Date: What is this all about??
  • Previous by thread: Re: pgsql and case preservation
  • Next by thread: What is this all about??
  • Index(es):
    • Date
    • Thread