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
|
---|
Replies are listed 'Best First'. | |
---|---|
Re: Getting column size/type From DBI
by LTjake (Prior) on Jul 22, 2002 at 16:59 UTC | |
by mpeppler (Vicar) on Jul 23, 2002 at 14:33 UTC | |
Re: Getting column size/type From DBI
by arturo (Vicar) on Jul 22, 2002 at 17:20 UTC | |
Re: Getting column size/type From DBI
by earthboundmisfit (Chaplain) on Jul 22, 2002 at 17:03 UTC | |
Re: Getting column size/type From DBI
by ehdonhon (Curate) on Jul 22, 2002 at 17:05 UTC | |
Re: Getting column size/type From DBI
by BigD (Scribe) on Jul 22, 2002 at 17:01 UTC |
Back to
Seekers of Perl Wisdom