sbf_close_pg: Close PostgreSQL Connection

In poissonconsulting/subfoldr2: Save and Load R Objects

Close PostgreSQL Connection

Description

Close the PostgreSQL connection when you are done using a database.

Usage

sbf_close_pg(conn)

Arguments

conn	A DBIConnection object, as returned by dbConnect().

Details

Wrapper on DBI::dbDisconnect(). It is important to remember to close connections or your database performance can decrease over time.

Value

TRUE (or errors).

See Also

Other postgresql functions: sbf_backup_pg(), sbf_create_pg(), sbf_execute_pg(), sbf_get_config_file(), sbf_get_config_value(), sbf_get_schema(), sbf_list_tables_pg(), sbf_load_data_from_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()

Examples

## Not run: 
conn <- sbf_open_pg()
sbf_close_pg(conn)

## End(Not run)

poissonconsulting/subfoldr2 documentation built on Nov. 17, 2024, 1:33 a.m.