1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
|
% Generated by roxygen2: do not edit by hand
% Please edit documentation in R/spec-meta-column-info.R
\docType{data}
\name{spec_meta_column_info}
\alias{spec_meta_column_info}
\title{spec_meta_column_info}
\value{
\code{dbColumnInfo()}
returns a data frame
with at least two columns \code{"name"} and \code{"type"} (in that order)
(and optional columns that start with a dot).
The \code{"name"} and \code{"type"} columns contain the names and types
of the R columns of the data frame that is returned from \code{\link[DBI:dbFetch]{DBI::dbFetch()}}.
The \code{"type"} column is of type \code{character} and only for information.
Do not compute on the \code{"type"} column, instead use \code{dbFetch(res, n = 0)}
to create a zero-row data frame initialized with the correct data types.
}
\description{
spec_meta_column_info
}
\section{Failure modes}{
An attempt to query columns for a closed result set raises an error.
}
\section{Specification}{
A column named \code{row_names} is treated like any other column.
The column names are always consistent
with the data returned by \code{dbFetch()}.
If the query returns unnamed columns,
non-empty and non-\code{NA} names are assigned.
Column names that correspond to SQL or R keywords are left unchanged.
}
\seealso{
Other meta specifications:
\code{\link{spec_get_info}},
\code{\link{spec_meta_bind}},
\code{\link{spec_meta_get_row_count}},
\code{\link{spec_meta_get_rows_affected}},
\code{\link{spec_meta_get_statement}},
\code{\link{spec_meta_has_completed}},
\code{\link{spec_meta_is_valid}}
}
\concept{meta specifications}
|
