in reply to Getting all the databases of a PostGreSQL database server.

You could query for this info too.

my $sql = 'SELECT datname FROM pg_database'; my @databases = map { $_->[0] } @{ $dbh->selectall_arrayref( $sql ) };

That query works with my PostgreSQL 8.3.3, but I haven't tried the Perl code.

Replies are listed 'Best First'.
Re^2: Getting all the databases of a PostGreSQL database server.
by pankaj_it09 (Scribe) on Jan 06, 2009 at 13:28 UTC
    I am using the dbhandle and its working.