Quoting Hardy Merrill <[EMAIL PROTECTED]>, who wrote: > 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
In case you're interested, the book describes the meaning of the values in the section on "metadata". Sam > 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. > -- Sam Roberts <[EMAIL PROTECTED]>
