FIESTAutils (version 1.3.1)

DBtestPostgreSQL: Database - Test a PostgreSQL database.

Description

Checks a PostgreSQL database.

Usage

DBtestPostgreSQL(
  dbname = NULL,
  host = NULL,
  port = NULL,
  user = NULL,
  password = NULL,
  dbconnopen = FALSE,
  showlist = TRUE,
  ...
)

Value

An S4 object that inherits from DBIConnection via the DBI package if dbconnopen = TRUE, or NULL otherwise. For more information, see `help(DBI::dbConnect)`.

Arguments

dbname

String. Name of the database on the host.

host

String. Host name.

port

String. Port number.

user

String. User name.

password

String. Password.

dbconnopen

Logical. If TRUE, the database connection is returned and not closed.

showlist

Logical. If TRUE, prints list of tables in database.

...

Additional authentication arguments passed to DBI::dbConnect

Author

Tracey S. Frescino