Last data update: 2014.03.03

R: Search the Database by Keys
%k%R Documentation

Search the Database by Keys

Description

Quick handle operator to search the database by keys. All time series whose key fit the regular expression which was handed to the operator are returned in a list.

Create ' This function creates a new function operator for a particular key. Name the function operator style to get the most out of it.

Usage

conObj %k% regexp

createMetaDataHandle(key, keep_keys = FALSE, tbl = "meta_data_unlocalized",
  schema = "timeseries")

Arguments

conObj

PostgreSQL Connection object.

regexp

character regular expression pattern. Do not set this manually, because the quick handle operator only takes two arguments. use Sys.setenv to change the schema.

key

character name of the key inside the hstore.

keep_keys

logical should primary time series keys be kept? Defaults to FALSE. If set to TRUE dynamically created meta information handlers always use ts_key as key type no matter the key type used for the query. This comes handy when storing sets of time series.

tbl

character name of the table that holds meta data. Defaults to meta_data_unlocalized. Also supports meta_data_localized

schema

character database schema name. Defaults to timeseries.

Results