Load data frames from a PostgreSQL database

Load all the tables in a PostgreSQL database schema into R as data frames.

Usage

sbfx_load_datas_from_pg(
  schema = getOption("psql.schema", "public"),
  rename = identity,
  env = parent.frame(),
  config_path = getOption("psql.config_path", NULL),
  config_value = getOption("psql.config_value", "default")
)

Arguments

schema

A string of the schema name. Default value is "public".

rename

A single function argument which takes a character vector and returns a character vector of the same length. Used to rename objects before they are loaded into the environment.

env

The environment to the objects into

config_path

A string of a file path to the yaml configuration file. The default value grabs the file path from the psql.config_path option and uses NULL if no value supplied.

config_value

A string of the name of value. The default value grabs the value from the psql.config_value option and uses "default" if no value is supplied.

Value

An invisible character vector of the paths to the saved objects.

See also

Other postgresql functions: sbfx_backup_pg(), sbfx_close_pg(), sbfx_create_pg(), sbfx_execute_pg(), sbfx_get_config_file(), sbfx_get_config_value(), sbfx_get_schema(), sbfx_list_tables_pg(), sbfx_load_data_from_pg(), sbfx_open_pg(), sbfx_reset_config_file(), sbfx_reset_config_value(), sbfx_reset_schema(), sbfx_save_data_to_pg(), sbfx_set_config_file(), sbfx_set_config_value(), sbfx_set_schema()

Other load functions: sbfx_load_data_from_pg()

Examples

if (FALSE) { # \dontrun{
sbfx_load_datas_from_pg()
sbfx_load_datas_from_pg(schema = "capture")
sbfx_load_datas_from_pg(rename = toupper)
} # }