sqliteBuildTableDefinition

0th

Percentile

Build the SQL CREATE TABLE definition as a string

The output SQL statement is a simple CREATE TABLE suitable for dbGetQuery

Keywords
internal
Usage
sqliteBuildTableDefinition(con, name, value, field.types = NULL,
  row.names = pkgconfig::get_config("RSQLite::row.names.query", FALSE))
Arguments
name

Name of the new SQL table

value

A data.frame, for which we want to create a table.

field.types

Optional, named character vector of the types for each field in value

row.names

Logical. Should row.name of value be exported as a row_names field? Default is TRUE

conn

A database connection.

Value

An SQL string

Aliases
  • sqliteBuildTableDefinition
  • dbBuildTableDefinition
Documentation reproduced from package RSQLite, version 2.0, License: LGPL (>= 2)

Community examples

Looks like there are no examples yet.