Re: Mixed Case Column Names

[prev] [thread] [next] [Date index for 2005/04/14]

On Thu, Apr 14, 2005 at 03:26:00PM +0100, Jay Hargreaves wrote:
> When I query the columns that are contained in the table:
> my @columns = TPG_Staging->columns;
> I receive a list of the columns as expected but with all the the names 
> in lower case. 

No you don't. You receive a list of Class::DBI::Column objects.

These are overloaded so that they stringify to the name of the column in
lower case. 

You can, however, ask them for their name, as given, with the name()
method.

So, for example, you could have:

  sub all_column_names { map $_->name, shift->columns }

Tony