dbGetInfo-methods

0th

Percentile

Database interface meta-data

These methods are straight-forward implementations of the corresponding generic functions.

Keywords
methods, interface, database
References

See the Database Interface definition document DBI.pdf in the base directory of this package or http://stat.bell-labs.com/RS-DBI.

See Also

SQLite, dbDriver, dbConnect, dbSendQuery, dbGetQuery, fetch, dbCommit, dbGetInfo, dbListTables, dbReadTable.

Aliases
  • dbGetInfo
  • dbGetDBIVersion-methods
  • dbGetStatement-methods
  • dbGetRowCount-methods
  • dbGetRowsAffected-methods
  • dbColumnInfo-methods
  • dbHasCompleted-methods
  • dbGetInfo,SQLiteObject-method
  • dbGetInfo,SQLiteDriver-method
  • dbGetInfo,SQLiteConnection-method
  • dbGetInfo,SQLiteResult-method
  • dbGetStatement,SQLiteResult-method
  • dbGetRowCount,SQLiteResult-method
  • dbGetRowsAffected,SQLiteResult-method
  • dbColumnInfo,SQLiteResult-method
  • dbHasCompleted,SQLiteResult-method
Examples
drv <- dbDriver("SQLite")
con <- dbConnect(drv)

dbListTables(con)

rs <- dbSendQuery(con, query.sql)
dbGetStatement(rs)
dbHasCompleted(rs)

info <- dbGetInfo(rs)
names(dbGetInfo(drv))  

# DBIConnection info
names(dbGetInfo(con))

# DBIResult info
names(dbGetInfo(rs))
Documentation reproduced from package RSQLite, version 0.4-13, License: LGPL version 2 or newer

Community examples

Looks like there are no examples yet.