Dbi/Schema

Syst has asked for the wisdom of the Perl Monks concerning the following question:

I am using ingres, and I hate it, but I am wondering if there is a way to print the schema for a table All I really need is a list
colname,type
so like
id,int(4)
I don't care if this is in parseable code or not, I just need to display it. I have tried using the ingres tools, and google to figure out how to do it in perl or just using the ingres stuff. There needs to be a utility for ingres like mysqldump?
Do any monks have any ideas?

Comment on Dbi/Schema

Replies are listed 'Best First'.
Re: Dbi/Schema by Juerd (Abbot) on Jan 22, 2005 at 20:05 UTC
Have you tried DBI's table_info, column_info, etcetera? Juerd # { site => 'juerd.nl', plp_site => 'plp.juerd.nl', do_not_use => 'spamtrap' }	[reply]
Re: Dbi/Schema by CountZero (Bishop) on Jan 22, 2005 at 20:08 UTC
DBD::Ingres docs say that it implements the methods that DBI requires, so you should be able to get the metadata of the database in the usual way. CountZero "If you have four groups working on a compiler, you'll get a 4-pass compiler." - Conway's Law	[reply]