dbServerFieldsCClassesEM: Server Side Table Column Stored Type C Classes

In AndreMikulec/econModel: Meaningful Social and Economic Data from ALFRED and elsewhere

Description

Get the internal table of database server columns.

Usage

dbServerFieldsCClassesEM(
  connName,
  name,
  temporary = FALSE,
  others = FALSE,
  env,
  display = TRUE,
  exec = TRUE
)

Arguments

connName	String. Default is "connEM". Contains the name of the variable that contains the name of the "connection" in the environment "env".
name	Table name string, length 1-2.
temporary	Logical. This is a temporary table or not.
others	Logical. Default is FALSE. Using PostgreSQL, Whether or not to also return the "others" column and values (e.g."sclass"). Values are in lowercase. Note, the returned column order may be mixed.
env	Environment. Default is the .Global environment. This is the environment to return the connection object "connEM".
display	Logical. Whether to display the query (defaults to TRUE).
exec	Logical. Whether to execute the query (defaults to TRUE).

Details

Typical (SQLite) columns:
NAME(chr)  TYPE(chr)

Typical SQLite column TYPE values:
TYPE: character double integer

Typical PostgreSQL  columns (others = TRUE):
NAME(chr), SCLASS(chr), TYPE(chr),
LEN(int), PRECISION(int), SCALE(int) NULLOK(logi)

Typical PostgreSQL column values:
SCLASS: character double integer logical Date
TYPE: TEXT FLOAT8 INTEGER BOOL DATE

Value

data.frame. Variables are "name" and "type" (optionally some "others"). "type" column values are lowercase.

AndreMikulec/econModel documentation built on June 30, 2021, 9:48 a.m.