Load a table from a PostgreSQL database

sbf_load_data_from_pg() was moved to subfoldr2ext::sbfx_load_data_from_pg().

Read/load a table from a PostgreSQL database as a data frame into R.

Usage

sbf_load_data_from_pg(
  x,
  schema = getOption("psql.schema", "public"),
  config_path = getOption("psql.config_path", NULL),
  config_value = getOption("psql.config_value", "default")
)

Arguments

x

A string of the table name

schema

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

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

A data frame

Details

Wrapper on psql::psql_read_table()

See also

Other postgresql functions: sbf_backup_pg(), sbf_close_pg(), sbf_create_pg(), sbf_execute_pg(), sbf_get_config_file(), sbf_get_config_value(), sbf_get_schema(), sbf_list_tables_pg(), sbf_load_datas_from_pg(), sbf_open_pg(), sbf_reset_config_file(), sbf_reset_config_value(), sbf_reset_schema(), sbf_save_data_to_pg(), sbf_set_config_file(), sbf_set_config_value(), sbf_set_schema()

Other load functions: sbf_load_block(), sbf_load_blocks(), sbf_load_blocks_recursive(), sbf_load_data(), sbf_load_data_from_db(), sbf_load_datas(), sbf_load_datas_from_db(), sbf_load_datas_from_pg(), sbf_load_datas_recursive(), sbf_load_db_metatable(), sbf_load_number(), sbf_load_numbers(), sbf_load_numbers_recursive(), sbf_load_object(), sbf_load_objects(), sbf_load_objects_recursive(), sbf_load_plot(), sbf_load_plot_data(), sbf_load_plots_data(), sbf_load_plots_data_recursive(), sbf_load_plots_recursive(), sbf_load_spatial(), sbf_load_spatials(), sbf_load_string(), sbf_load_strings(), sbf_load_strings_recursive(), sbf_load_table(), sbf_load_tables(), sbf_load_tables_recursive(), sbf_load_windows_recursive(), sbf_subs_block_recursive(), sbf_subs_data_recursive(), sbf_subs_number_recursive(), sbf_subs_object_recursive(), sbf_subs_plot_recursive(), sbf_subs_string_recursive(), sbf_subs_table_recursive(), sbf_subs_window_recursive()

Examples

if (FALSE) { # \dontrun{
sbf_load_data_from_pg("capture")
sbf_load_data_from_pg("counts", "boat_count")
} # }