Utilities {RPgSQL}R Documentation

RPgSQL utility functions

Description

format.table.name converts R names with dot seperators to postgres friendly names with underscore separators.
check.table.name calls format.table.name and then verifies that the table exists in the current database.
make.db.namess replaces periods with underscores.
list.to.csv converts a list of values to a string containing comma separated values.
single.quote wraps strings with single quotes.
double.quote wraps strings with double quotes.
format.null.values returns R NULL values where needed.

Usage

format.table.name(table.name)
check.table.name(table.name)
make.db.names(name)
list.to.csv(...)
single.quote(...)
double.quote(...)
format.null.values(...)

Arguments

table.name A character string containing the name of a postgres table or a proxy object pointing to a postgres table
name A character string with R names
... A list of values to format

Details

If a db.proxy object is passed to convert.table.name, the postgres table name will be extracted from the proxy and returned.

When calling check.table.name, if the table does not exist, then stop is called and a warning issued. A db.proxy object may also be passed to check.table.name, in which case the table name is extracted from the proxy object.

Author(s)

Timothy H. Keitt