Re^3: DBI:how to get name of the db ?

In other words, it holds the part after the driver indication in the DSN part. When e.g. connecting to CSV like

my $dbh = DBI->connect ("dbi:CSV:f_ext=.csv/r;f_encoding=utf-8", undef
+, undef, { RaiseError => 1 });
[download]

The return values for $dbh->{Name} will be f_ext=.csv/r;f_encoding=utf-8, which might not be very useful information.

The fact the DBD::Pg in your case returns the correct database name, might be because you initiated the connection using something like

my $dbh = DBI->connect ("dbi:Pg:dbname=test", ...);
[download]

but when you connect using just "dbi:Pg:" in combination with the environment variable $PGDATABASE, you might not get anything useful at all

$ env PGDATABASE=merijn perl -MDBI -wE'say DBI->connect("dbi:Pg:")->{N
+ame}||"not known"'
not known
$
[download]

Enjoy, Have FUN! H.Merijn

Comment on Re^3: DBI:how to get name of the db ? Select or Download Code

Replies are listed 'Best First'.
Re^4: DBI:how to get name of the db ? by erix (Prior) on Dec 14, 2011 at 12:04 UTC
The fact the DBD::Pg in your case returns the correct database name, We are in complete agreement. You just didn't read my post well ;-) I log 'passwordless' into postgres with PGPASSFILE and friends (PGHOST, PGPORT, PGDATABASE), so my $dbh->{'Name'} returns empty. (and btw, your example ("dbi:Pg:dbname=test", ...) will return not 'test', but 'dbname=test', although I suppose you understand that. (Apparently DBD::Pg was actually changed a while ago to give this DBI-compliant behavior, instead of the database name.))	[reply]

Replies are listed 'Best First'.

Re^4: DBI:how to get name of the db ?
by erix (Prior) on Dec 14, 2011 at 12:04 UTC

The fact the DBD::Pg in your case returns the correct database name,

We are in complete agreement. You just didn't read my post well ;-) I log 'passwordless' into postgres with PGPASSFILE and friends (PGHOST, PGPORT, PGDATABASE), so my $dbh->{'Name'} returns empty.

(and btw, your example ("dbi:Pg:dbname=test", ...) will return not 'test', but 'dbname=test', although I suppose you understand that. (Apparently DBD::Pg was actually changed a while ago to give this DBI-compliant behavior, instead of the database name.))

[reply]