Re: How to extract db hostname from the $dbh handle?
[email protected] ("Greg Sabino Mullane")
| Newsgroups | perl.dbi.users |
|---|---|
| Message-ID | <[email protected]> |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160
>> my $host = $dbh->{pg_host};
>>
>> If your driver doesn't have that, bug the author, or perhaps
>> even petition to have it added to DBI.
> This may not be possible in the general case. For some databases (e.g.,
> Oracle, probably ODBC) you pass in an opaque identifier which is
> resolved by the library, not the DBD.
Sure, I was merely envisioning a generic wrapper in DBI that defaulted
to returning nothing - it becomes each driver's responsibility to
override and provide information to it. I'm not sure why Oracle
couldn't do this as well - why not just peek at USERENV.SERVER_HOST
via SYS_CONTEXT?
- --
Greg Sabino Mullane [email protected]
End Point Corporation http://www.endpoint.com/
PGP Key: 0x14964AC8 201003151003
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----
iEYEAREDAAYFAkueP4QACgkQvJuQZxSWSsi6XwCfbTOPu5ycWR6cZ6wvswEvPTPB
NN4An2HDCjcwBch9sFg3DFkNS9GJNhfz
=vTVB
-----END PGP SIGNATURE-----