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

Description Usage Arguments Value Examples

View source: R/dplyr.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

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)

MonetDB.R documentation built on May 19, 2017, 3:30 p.m.

Search within the MonetDB.R package
Search all R packages, documentation and source code

Questions? Problems? Suggestions? Tweet to @rdrrHQ or email at ian@mutexlabs.com.

Please suggest features or report bugs in the GitHub issue tracker.

All documentation is copyright its authors; we didn't write any of that.