Utilities {RPgSQL} | R Documentation |
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.
format.table.name(table.name) check.table.name(table.name) make.db.names(name) list.to.csv(...) single.quote(...) double.quote(...) format.null.values(...)
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 |
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.
Timothy H. Keitt