rpg: Easy Interface to Advanced PostgreSQL Features
Version 1.5

Allows ad hoc queries and reading and writing data frames to and from a database.

Browse man pages Browse package API and functions Browse package files

AuthorTimothy H. Keitt
Date of publication2017-02-08 16:54:11
MaintainerTimothy H. Keitt <tkeitt@gmail.com>
LicenseGPL (>= 2)
Version1.5
URL http://github.com/thk686/rpg http://www.keittlab.org/
Package repositoryView on CRAN
InstallationInstall the latest version of this package by entering the following in R:
install.packages("rpg")

Man pages

async: Asynchronous query processing
connection: PostgreSQL connection
connection-utils: Database connection utilities
copy: Bulk read and write
cursor: Iterator support
format-for-send: Convert R objects to strings
misc: Miscelaneous functions
path: PostgreSQL path variable
prepare: Prepared queries
psql: PostgreSQL shell
query: PostgreSQL query
rpg-package: Easy Access to Advanced PostgreSQL Features
sql: Create an index
stack: Multiple PostgreSQL connections
stow: Object storage
table-info: PostgreSQL database information
table-io: PostgreSQL data frame IO
tracing: PostgeSQL connection tracing
transactions: Transaction support

Functions

add_column Man page Source code
add_foreign_key Man page Source code
add_primary_key Man page Source code
append_path Man page Source code
as.csv Source code
async_query Man page Source code
async_status Man page Source code
begin Man page Source code
cancel Man page Source code
check_schema Source code
check_stow Source code
check_transaction Source code
clean_up_all Source code
commit Man page Source code
connect Man page Source code
connect_ Source code
copy_from Man page Source code
copy_to Man page Source code
create_index Man page Source code
create_schema Man page Source code
createdb Man page Source code
cursor Man page Source code
delete_stowed Man page Source code
describe_table Man page Source code
disconnect Man page Source code
disconnect_ Source code
dquote_esc Source code
dropdb Man page Source code
dump_conn_trace Man page Source code
enable_extension Man page Source code
enable_postgis Man page Source code
encrypt_password Man page Source code
exec_param_serialize Source code
execute Man page Source code
execute_prepared_ Source code
fetch Man page Source code
fetch_dataframe Source code
fetch_matrix Source code
fetch_stowed Source code
finish_async Man page Source code
format_for_send Man page Source code
format_for_send.Date Source code
format_for_send.data.frame Source code
format_for_send.default Source code
format_for_send.list Source code
format_tablename Source code
get_conn_defaults Man page Source code
get_conn_error Man page Source code
get_conn_info Man page Source code
get_conn_info_ Source code
get_encoding Man page Source code
get_path Man page Source code
get_pw Source code
get_tuple_info Source code
handle_row_names Source code
is_busy Man page Source code
is_non_empty_string Source code
libpq_version Man page Source code
list_databases Man page Source code
list_schema Man page Source code
list_stowed Man page Source code
list_tables Man page Source code
make_service Man page Source code
num_prepared_params Source code
onLoad Source code
onUnload Source code
path_contains Man page Source code
pg_type Source code
ping Man page Source code
pop_conn Man page Source code
prepare Man page Source code
prepare_ Source code
prepend_path Man page Source code
primary_key_name Source code
print.conn.info Source code
print.message Source code
print.pg.trace.dump Source code
print.pq.error.message Source code
print.pq.status Source code
proc_psql_opts Source code
proc_psql_passwd Source code
psql Man page Source code
push_conn Man page Source code
query Man page Source code
query_error Man page Source code
read_table Man page Source code
register_return_formatter Man page Source code
reset_conn_defaults Man page Source code
result_dim Man page Source code
retrieve Man page Source code
retrieve_image Man page Source code
rollback Man page Source code
rotate_stack Man page Source code
rpg Man page
rpg-package Man page
run_examples Source code
savepoint Man page Source code
set_conn_defaults Man page Source code
set_default_password Man page Source code
set_encoding Man page Source code
set_error_verbosity Man page Source code
set_path Man page Source code
set_prompt Source code
show_conn_stack Man page Source code
sql Man page
stow Man page Source code
stow_image Man page Source code
strip_quotes Source code
swap_conn Man page Source code
table_exists Source code
toggle_echo Man page Source code
trace_conn Man page Source code
trace_filename Man page Source code
unique_name Source code
unique_statement_id Source code
untrace_conn Man page Source code
write_table Man page Source code

Files

src
src/libpq-fe.h
src/rpg.cpp
src/get-pgversion.R
src/rpg.h
src/Makevars.in
src/postgres_ext.h
src/pg_config_ext.h
src/Makevars.win
src/RcppExports.cpp
src/get-libpq.R
NAMESPACE
R
R/utils.R
R/rpg.R
R/RcppExports.R
R/sql.R
MD5
DESCRIPTION
configure
man
man/connection.Rd
man/cursor.Rd
man/path.Rd
man/copy.Rd
man/table-info.Rd
man/stack.Rd
man/rpg-package.Rd
man/async.Rd
man/prepare.Rd
man/connection-utils.Rd
man/psql.Rd
man/stow.Rd
man/transactions.Rd
man/query.Rd
man/sql.Rd
man/format-for-send.Rd
man/misc.Rd
man/tracing.Rd
man/table-io.Rd
configure.win
tools
tools/winlibs.R
rpg documentation built on May 19, 2017, 5:37 p.m.