MonetDB.R (version 0.9.4)

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

monetdb_queryinfo("demo","SELECT 1")