dbColumnInfo
From DBI v0.3.0
by Hadley Wickham
Information about result types.
Produces a data.frame that describes the output of a query. The data.frame should have as many rows as there are output fields in the result set, and each column in the data.frame should describe an aspect of the result set field (field name, type, etc.)
Usage
dbColumnInfo(res, ...)Arguments
- res
- An object inheriting from
DBIResult - ...
- Other arguments passed on to methods.
Value
- A data.frame with one row per output field in
res. Methods MUST includename,field.type(the SQL type), anddata.type(the R data type) columns, and MAY contain other database specific information like scale and precision or whether the field can storeNULLs.
See Also
Other DBIResult generics: dbClearResult;
dbFetch,
dbFetch,DBIResult-method,
fetch; dbGetRowCount,
dbGetRowCount,DBIResult-method;
dbGetRowsAffected,
dbGetRowsAffected,DBIResult-method;
dbGetStatement,
dbGetStatement,DBIResult-method;
dbHasCompleted,
dbHasCompleted,DBIResult-method
Community examples
Looks like there are no examples yet.