DBI (version 0.3.0)

dbGetInfo: Get DBMS metadata.

Description

Get DBMS metadata.

Usage

dbGetInfo(dbObj, ...)

Arguments

dbObj
An object inheriting from DBIObject, i.e. DBIDriver, DBIConnection, or a DBIResult
...
Other arguments to methods.

Value

  • a named list

Implementation notes

For DBIDriver subclasses, this should include the version of the package (driver.version), the version of the underlying client library (client.version), and the maximum number of connections (max.connections).

For DBIConnection objects this should report the version of the DBMS engine (db.version), database name (dbname), username, (username), host (host), port (port), etc. It MAY also include any other arguments related to the connection (e.g., thread id, socket or TCP connection type). It MUST NOT include the password.

For DBIResult objects, this should include the statement being executed (statement), how many rows have been fetched so far (in the case of queries) (row.count), how many rows were affected (deleted, inserted, changed, or total number of records to be fetched). (rows.affected), if the query is complete (has.completed), and whether or not the query generates output (is.select).

See Also

Other DBObject methods: dbIsValid