[CDBI] Re: postgres and case sensitive table names
cvicente at network-services.uoregon.edu
Thu Jun 28 19:38:15 BST 2007
Edward J. Sabol wrote:
> Carlos Vicente wrote:
>> I have a large application that has been using MySQL until now. I
>> started looking at what would be necessary to allow the user to use
>> Pg instead. My table names (not column names) have mixed
>> upper/lowercase letters. I am able to create those tables in Pg with
>> the same names by enclosing them in double quotes, but it looks like
>> the SQL that CDBI generates would need to also enclose those table
>> names in double quotes.
> Try a variation of the following:
> Hope this helps,
That seems to do the trick. Thank you!
More information about the ClassDBI