BigGuy has asked for the wisdom of the Perl Monks concerning the following question:
<DISCLAIMER> this is more of a database question than a straight perl question </DISCLAIMER>
I have been doing a lot of database coding in perl lately and have a DBD::Pg question. Is there an easy way to get column size and/or column type from the DBI? Currently I am using a very poor system where i keep track of the largest length in each column as i work the data over, which leads to slower runtimes and more memory usage and in general just looks bad if anyone else were ever to look at my code. I use pgaccess and ipgsql and both of these have features that will tell you the column type and size which leads me to think that the DBI must have a similar feature.
BigGuy
"One World, one Web, one Program" - Microsoft promotional ad
"Ein Volk, ein Reich, ein Fuhrer" - Adolf Hitler
I have been doing a lot of database coding in perl lately and have a DBD::Pg question. Is there an easy way to get column size and/or column type from the DBI? Currently I am using a very poor system where i keep track of the largest length in each column as i work the data over, which leads to slower runtimes and more memory usage and in general just looks bad if anyone else were ever to look at my code. I use pgaccess and ipgsql and both of these have features that will tell you the column type and size which leads me to think that the DBI must have a similar feature.
BigGuy
"One World, one Web, one Program" - Microsoft promotional ad
"Ein Volk, ein Reich, ein Fuhrer" - Adolf Hitler
Back to
Seekers of Perl Wisdom