monetdb_queryinfo: Get information about the result set of a query without...

In MonetDB.R: Connect MonetDB to R

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")

## End(Not run)

MonetDB.R documentation built on May 29, 2017, 5:43 p.m.