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

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

get_all_tables_data(
  pool_conn,
  schemaname = "public",
  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
prefix

String to prefix the variables with
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