No such thing as a small change | |
PerlMonks |
Re: DBI:how to get name of the db ?by erix (Prior) |
on Dec 14, 2011 at 09:22 UTC ( [id://943506]=note: print w/replies, xml ) | Need Help?? |
For the sake of completeness: SQL-standard compliant databases have table information_schema_catalog_name, which always contains one row and one column containing the name of the current database (the current 'catalog', in SQL terminology). (The SQL standard says "The value of CATALOG_NAME is the name of the catalog in which this Information Schema resides.") PostgreSQL example:
I'd normally prefer DBI, but the SQL can be handy. (And FWIW: postgres also supports the more succinct and standard-compliant CURRENT_CATALOG:)
And then there is DBI's get_info stuff:
update: Jenda: Re SQL-standard versions: PostgreSQL supports generally quite recent versions: SQL:2011 and SQL:2008. And even SQL92 already prescribed INFORMATION_SCHEMA_CATALOG_NAME. Some systems are more SQL-compliant than others. PostgreSQL tries quite hard to implement as much as possible.
In Section
Seekers of Perl Wisdom
|
|