in reply to
Re: How to give a database as an input in a perl script?
in thread How to give a database as an input in a perl script?
my $dbh = DBI->connect(...);
my @tables = $dbh->tables(undef, undef, undef, 'TABLE');
print "$_\n" for @tables;
method should work for all databases supported by DBI. Sending a show tables
query is MySQL-specific - I know it doesn't work with SQLite databases and, from long-gone memory, I'm pretty sure PostgreSQL wouldn't like it either. Any other database engine, I can only say "seems unlikely".