This function is not exported. It creates a tempory table containing the keys that should be read to join them against the time series storage. This is much faster for larger selections than simple where clauses.
db_with_tmp_read(con, ts_keys, regex = FALSE, code, schema = "timeseries")RPostgres connection object.
character vector of time series identifiers.
logical if set to TRUE, the ts_keys parameter is interpreted as a regular expression pattern.
expression Code to be evaluated after populating the temporary table on the database of a time series that is valid from the specified date.
character name of the database schema. Defaults to 'timeseries'