hrsampleCreatePostgreSQL: Load hrsample to PostgreSQL

In harryahlas/hrsample: A Sample Human Resources Database for Educational Purposes

Description

This function loads the hrsample tables to a PostgreSQL database that the user has access to. It utilizes the RPostgres package and its dependency, DBI. The parameters are based on the DBI parameters.

Usage

hrsampleCreatePostgreSQL(dbname = NULL, host = NULL, user = NULL,
  password = NULL, port = 5432)

Arguments

dbname	The name of the database the tables will be stored to. Must be a preexisting database. Ideal name would be "hrsample". This function does not create a new database.
host	Name of the host. If working with a remote database, may be something like "johnny.heliohost.org". If working with a database on your local machine it might be "localhost" or "127.0.0.1".
user	Username to log into database
password	Password for user

Examples

hrsampleCreatePostgreSQL()

harryahlas/hrsample documentation built on July 22, 2019, 11:06 p.m.