get_all_tables_data: Get data from all tables in a schema. Each as a separate...

In Aypak/dbhelpers: Helper Functions for Common Database Operations

Get data from all tables in a schema. Each as a separate data.frame

Description

Get data from all tables in a schema. Each as a separate data.frame

Usage

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

Arguments

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

Value

A data.frame for each of the tables in the specified schema

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