If you like you can review the "data_sources" subroutine defined here:
https://metacpan.org/pod/DBI
If you find the completely Generic way to list databases Lacking - here are few
particular solutions:
In Particular for PostgreSQL:
This lists databases:
SELECT datname as database
FROM pg_databa
On Friday 16 November 2018 17:04:50 Marius Feraru wrote:
> On Fri, Nov 16, 2018 at 10:38 AM wrote:
> > Hi! If you want to list all databases then use DBI's data_sources method:
> > https://metacpan.org/pod/DBI#data_sources
>
> And DBD::mysql points to this method for a while:
> https://github.com
On Fri, Nov 16, 2018 at 10:38 AM wrote:
> Hi! If you want to list all databases then use DBI's data_sources method:
> https://metacpan.org/pod/DBI#data_sources
And DBD::mysql points to this method for a while:
https://github.com/perl5-dbi/DBD-mysql/blame/9f96fab985327773397a60020f5dcb76dfd8c396/l
IMHO, listing databases is not well-defined in a cross-RDBMS context, since the
definition of database largely differs between RDBMS products. As an example,
"database" even has different definitions between Db2 for Linux/Unix/Windows on
the one hand, and Db2 for z/OS on the other hand!
What sh
What you seek is not possible, in any general sense.
The concept of "what is a database" varies too greatly between different DBMS
products, even if you restrict yourself to SQL DBMSs. Loosely the question is
like asking for a "list of websites".
If what you want is to have a product or serv
kinds and you should at least be able to keep all the messiness in
one subroutine.
From: Scott Webster Wood via dbi-users
Sent: Friday, November 16, 2018 10:26 AM
To: dbi-users@perl.org; Daniel Kasak
Subject: Re: Generic way of fetching a list of databases
convert to 'rest
convert to 'rest'ful JSON?
Barack-O-phobia: The fear of politicians who think (more) government is
the solution to every problem.
On Thursday, November 15, 2018, 9:09:44 PM EST, Daniel Kasak
wrote:
Hi all.
I have a project that has to support pretty much every major database arou
On Friday 16 November 2018 13:09:21 Daniel Kasak wrote:
> Hi all.
>
> I have a project that has to support pretty much every major database
> around, plus a number of more esoteric "big data" platforms as well. Until
> now, I've had a bunch of methods, implementing fetching databases, schemas,
> t
Hi all.
I have a project that has to support pretty much every major database
around, plus a number of more esoteric "big data" platforms as well. Until
now, I've had a bunch of methods, implementing fetching databases, schemas,
tables, etc, per database, with database-specific queries ( eg agains
