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

View source: R/get_all_tables_data.R

get_all_tables_dataR Documentation

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 Sept. 20, 2022, 3:05 p.m.