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.
install_timeseriesdb(
con,
schema = "timeseries",
verbose = FALSE,
install_tables = TRUE,
install_functions = TRUE
)RPostgres connection object.
character name of the database schema. Defaults to 'timeseries'
boolean Should progress messages be printed? Default FALSE
boolean Should the tables be created? Default TRUE
boolean Should the functions be installed? Default TRUE
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.