lazy_conn_all_tables: Create lazy connections to all tables in a schema as separate...

In Aypak/dbhelpers: Helper Functions for Common Database Operations

Create lazy connections to all tables in a schema as separate variables

Description

Create lazy connections to all tables in a schema as separate variables

Usage

lazy_conn_all_tables(
  pool_conn,
  schemaname = "public",
  table_types = c("BASE TABLE", "FOREIGN", "VIEW", "LOCAL TEMPORARY"),
  prefix = "",
  env = globalenv()
)

Arguments

pool_conn	A pool connection to a PostgreSQL database
schemaname	The schema from which to get the tables. Default is public
table_types	The types of tables to connect to. Default is base tables, foreign tables, views and local temporary tables
prefix	String to prefix the variables with
env	The environment in which to create the variables. Default is global environment

Value

Variables for lazy connections to each of the tables in the environment specified

Aypak/dbhelpers documentation built on Jan. 25, 2024, 9:03 p.m.