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

Share:

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

1
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

1
2
3
4
## Not run: 
  monetdb_queryinfo("demo","SELECT 1")

## End(Not run)