get_table_design: Get table design

In tomasgreif/mondrianr: Create Mondrian schema in R

Description

This function returns data frame with structure of specified table for given data engine. If successful, dataset with the following columns is returned:

Column	Description
name	Class of data type.
type	Data type as defined by data engine. This is used to map data type to default schema properties as defined in get_default_mapping.
schema	Database schema. If not specified for given data engine than NA

Usage

get_table_design(engine = NA, table = NA, con = NA, debug = FALSE)

Arguments

engine	Data engine. See function create_schema for details.
table	Table to be analyzed.
con	Connection. See function create_schema for details.
debug	Print additional information useful for debugging.

Examples

get_table_design(engine='R', table='iris')

## Not run: 
get_table_design(engine='PostgreSQL',
 table='public.big_portfolio',con=c('usr','pwd','db','host','port'))
## End(Not run)

tomasgreif/mondrianr documentation built on May 31, 2019, 5:15 p.m.