MonetDB.R (version 1.0.1)

monetdb_queryinfo: Get information about the result set of a query without actually executing it. This is mainly needed for dplyr compatibility.

Description

monetdb_queryinfo(...) is used to get the expected result set structure (# rows, # columns, column names, column types etc.) without actually running the query.

Usage

monetdb_queryinfo(conn, query)

Arguments

conn

Database name

query

SQL SELECT query to get information about

Value

Environment with various entries, e.g.

• cols -- number of columns

• rows -- number of rows

• types -- vector of column type from database (e.g. "VARCHAR" or "INT")

• names -- vector of column names

• tables -- vector of table names

Examples

# NOT RUN {
  monetdb_queryinfo("demo","SELECT 1")
# }