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
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:
>
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:
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
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
Closest thing that I know of is INFORMATION_SCHEMA and the
INFORMATION_SCHEMA.TABLES pseudo table.
INFORMATION_SCHEMA is a standard across many databases. One Database that
doesn’t comply is Oracle (but it can be installed by the DBA as an Add-on) for
Oracle select from ALL_TABLES (or
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
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,
>