install_timeseriesdb: Install timeseriesdb

In timeseriesdb: A Time Series Database for Official Statistics with R and PostgreSQL

Install timeseriesdb

Description

Install timeseriesdb in a given PostgreSQL schema. Make sure the database user has sufficient rights to perform the necessary operations on the schema. In the process tables, roles, triggers and functions will be created. Also extensions will be installed and rights will be granted and revoked from the freshly created roles. Note also, that the functions created are created as SECURITY DEFINER roles.

Usage

install_timeseriesdb(
  con,
  schema = "timeseries",
  verbose = FALSE,
  install_tables = TRUE,
  install_functions = TRUE
)

Arguments

con	RPostgres connection object.
schema	character name of the database schema. Defaults to 'timeseries'
verbose	boolean Should progress messages be printed? Default FALSE
install_tables	boolean Should the tables be created? Default TRUE
install_functions	boolean Should the functions be installed? Default TRUE

Details

install_tables and install_functions can be used to install components of timeseriesdb independently (e.g. only update function definitions without touching the table structure). They are used mainly for development purposes.

timeseriesdb documentation built on March 24, 2022, 1:06 a.m.