searchHstore: Search Key-Value Pairs, look for existing keys in an Hstore

Description Usage Arguments

Description

Search hstore key value in PostgreSQL. Very handsome when crawling the database by meta informaiton. Currently works for non translated meta information.

Usage

1
2
3
4
5
6
7
searchKVP(key, value, con = get(Sys.getenv("TIMESERIESDB_CON")),
  hstore = "meta_data", tbl = "meta_data_unlocalized", where = NULL,
  schema = "timeseries")

lookForKey(key, con = get(Sys.getenv("TIMESERIESDB_CON")),
  hstore = "meta_data", tbl = "meta_data_unlocalized", where = NULL,
  schema = "timeseries")

Arguments

key

character

value

in the hstore

con

PostgreSQL connection object

hstore

name of the hstore column

tbl

name of the table to be queried. defaults to 'meta_data_localized'

where

character restrict the SQL query by an additional where clause. Defaults to NULL.

schema

SQL schema name. defaults to timeseries. E.g.: ts_key LIKE ...


timeseriesdb documentation built on May 29, 2017, 5:12 p.m.

Search within the timeseriesdb package
Search all R packages, documentation and source code