Sam Roberts [[EMAIL PROTECTED]] wrote: > 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".
Thanks Sam - I would have looked at it but I don't have the book with me today :-) But I do have the script so I thought I would give as much info as I could. > > 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]> -- Hardy Merrill Mission Critical Linux, Inc. http://www.missioncriticallinux.com
