The book "Programming the Perl DBI" describes how to get
table metadata - I typed in the example, and here's the
kind of output it prints:
Column Name Type Precision Scale Nullable?
------------------------------ ---- --------- ----- ---------
The "Type" column prints out an integer indicating the
type of data the column is, but I'm not sure how to decypher
that integer type. You can find this script in the Chapter 6
examples at
http://examples.oreilly.com/perldbi/
just download the perldbi-src.tar.gz and unpack it, go into the
chapter 6 directory - it is the file called "tabledump".
BTW, "Programming the Perl DBI" is a very good book in my opinion,
so if you plan to do much DBI programming, my advice is to buy
a copy.
HTH.
--
Hardy Merrill
Mission Critical Linux, Inc.
http://www.missioncriticallinux.com
Cliff [[EMAIL PROTECTED]] wrote:
> Hey there,
>
>
> I am looking for a way to get the data_type info for each column for several
> tables.
> Ie I wish to loop over several tables and build a profile of the column type
> per table.
>
>
> Anyone got any advice please?
>
> Cheers :)
>
>
> Cliff.
