[CDBI] Re: postgres and case sensitive table names

"Edward J. Sabol" <sabol-2oVx0MVsMgiP/[email protected]> Wed, 27 Jun 2007 22:22:20 -0400
Newsgroups gmane.comp.lang.perl.modules.class-dbi
Message-ID <[email protected]>
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