PostgreSQL access


[Package List] [Top]
$.db.proxy Bind a proxy object to a PostgreSQL table
$<-.db.proxy Bind a proxy object to a PostgreSQL table
as.data.frame.db.proxy Bind a proxy object to a PostgreSQL table
as.list.db.proxy Bind a proxy object to a PostgreSQL table
as.matrix.db.proxy Bind a proxy object to a PostgreSQL table
bind.db.proxy Bind a proxy object to a PostgreSQL table
check.table.name RPgSQL utility functions
db.clear.result Send commands to the PostgreSQL back end
db.connect Open and manage database connection
db.connection.open Open and manage database connection
db.connection.options Open and manage database connection
db.connection.port Open and manage database connection
db.connection.status Open and manage database connection
db.debug.tty Open and manage database connection
db.disconnect Open and manage database connection
db.error.message Open and manage database connection
db.execute Send commands to the PostgreSQL back end
db.fetch.result Read query results into a data frame
db.has.row.names Bind a proxy object to a PostgreSQL table
db.host.name Open and manage database connection
db.ls list database tables
db.name Open and manage database connection
db.password Open and manage database connection
db.read.column Read query results into a data frame
db.read.table Read query results into a data frame
db.result.column.names Information about the result buffer
db.result.column.number Information about the result buffer
db.result.column.type Information about the result buffer
db.result.columns Information about the result buffer
db.result.get.value Fetch a value from returned tuples
db.result.rows Information about the result buffer
db.result.status Send commands to the PostgreSQL back end
db.rm list database tables
db.table.exists list database tables
db.table.name Bind a proxy object to a PostgreSQL table
db.toggle.echo Send commands to the PostgreSQL back end
db.user.name Open and manage database connection
db.write.table Write an R data frame into a PostgreSQL table
dim.db.proxy Bind a proxy object to a PostgreSQL table
dimnames.db.proxy Bind a proxy object to a PostgreSQL table
double.quote RPgSQL utility functions
Execute queries Send commands to the PostgreSQL back end
format.null.values RPgSQL utility functions
format.table.name RPgSQL utility functions
List database tables list database tables
list.to.csv RPgSQL utility functions
make.db.names RPgSQL utility functions
Manage connections Open and manage database connection
names.db.proxy Bind a proxy object to a PostgreSQL table
print.db.proxy Bind a proxy object to a PostgreSQL table
Proxy interface Bind a proxy object to a PostgreSQL table
psql Run the PostgreSQL monitor
Read from database Read query results into a data frame
Result attributes Information about the result buffer
row.names.db.proxy Bind a proxy object to a PostgreSQL table
rpgsql.cast.values Conversion between R and PostgreSQL data types
rpgsql.data.type Conversion between R and PostgreSQL data types
rpgsql.format.values Conversion between R and PostgreSQL data types
single.quote RPgSQL utility functions
sql.insert Append data to a PostgreSQL table
sql.select Format and optionally execute an SQL select query
sql.update Update data in a column of a PostgreSQL table
summary.db.proxy Bind a proxy object to a PostgreSQL table
Type conversions Conversion between R and PostgreSQL data types
Utilities RPgSQL utility functions
[.db.proxy Bind a proxy object to a PostgreSQL table
[<-.db.proxy Bind a proxy object to a PostgreSQL table
[[.db.proxy Bind a proxy object to a PostgreSQL table
[[<-.db.proxy Bind a proxy object to a PostgreSQL table