[CDBI] Re: postgres and case sensitive table names

Carlos Vicente 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:
>
> __PACKAGE__->table('"YourMixedCaseTableName"');
>
> Hope this helps,
> Ed
>   


That seems to do the trick.  Thank you!

cv



More information about the ClassDBI mailing list