spec_driver_get_info

spec_driver_get_info

spec_connection_get_info

spec_meta_get_info_result

Value

For objects of class DBI::DBIDriver, dbGetInfo() returns a named list that contains at least the following components:

• driver.version: the package version of the DBI backend,

• client.version: the version of the DBMS client library.

For objects of class DBI::DBIConnection, dbGetInfo() returns a named list that contains at least the following components:

• db.version: version of the database server,

• dbname: database name,

• username: username to connect to the database,

• host: hostname of the database server,

• port: port on the database server. It must not contain a password component. Components that are not applicable should be set to NA.

For objects of class DBI::DBIResult, dbGetInfo() returns a named list that contains at least the following components:

• statatment: the statement used with DBI::dbSendQuery() or DBI::dbExecute(), as returned by DBI::dbGetStatement(),

• row.count: the number of rows fetched so far (for queries), as returned by DBI::dbGetRowCount(),

• rows.affected: the number of rows affected (for statements), as returned by DBI::dbGetRowsAffected()

• has.completed: a logical that indicates if the query or statement has completed, as returned by DBI::dbHasCompleted().

See also

Other driver specifications: spec_driver_connect, spec_driver_constructor, spec_driver_data_type

Other connection specifications: spec_connection_disconnect

Other meta specifications: spec_meta_bind, spec_meta_column_info, spec_meta_get_row_count, spec_meta_get_rows_affected, spec_meta_get_statement, spec_meta_has_completed, spec_meta_is_valid