[CDBI] Re: postgres and case sensitive table names

Edward J. Sabol sabol at alderaan.gsfc.nasa.gov
Thu Jun 28 03:22:20 BST 2007


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



More information about the ClassDBI mailing list