retrieving column names from a table using DBI module

[Manisha Gupta]

Hello
I am working with Perl CGi. There is a query where i have to select all columns in  a 
table and display the data on the web page.
the query is something like 
"select * from <tablename>
But the problem is I am not able to get the column names.
I am using the DBI module. Is there a way to get column names?

Thanks