rpg: Easy Interface to Advanced PostgreSQL Features
Version 1.4

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

AuthorTimothy H. Keitt
Date of publication2015-02-21 17:25:43
MaintainerTimothy H. Keitt <tkeitt@gmail.com>
LicenseGPL (>=2)
Version1.4
URL http://www.postgresql.org/ http://github.com/thk686/rpg http://r-forge.r-project.org/projects/rpg/ http://www.keittlab.org/
Package repositoryView on R-Forge
InstallationInstall the latest version of this package by entering the following in R:
install.packages("rpg", repos="http://R-Forge.R-project.org")

Getting started

Package overview

Popular man pages

connection: PostgreSQL connection
copy: Bulk read and write
misc: Miscelaneous functions
rpg-package: Easy Access to Advanced PostgreSQL Features
stow: Object storage
table-io: PostgreSQL data frame IO
transactions: Transaction support
See all...

All man pages Function index File listing

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
prepare: Prepared queries
psql: PostgreSQL shell
query: PostgreSQL query
rpg-package: Easy Access to Advanced PostgreSQL Features
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

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
cursor Man page Source code
delete_stowed Man page Source code
describe_table Man page Source code
disconnect Man page Source code
dquote_esc Source code
dump_conn_trace 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_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_stowed Man page Source code
list_tables Man page Source code
num_prepared_params Source code
onLoad Source code
onUnload 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
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
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
show_conn_stack Man page Source code
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
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

DESCRIPTION
NAMESPACE
R
R/RcppExports.R
R/rpg.R
R/utils.R
cleanup
configure
configure.in
configure.win
man
man/async.Rd
man/connection-utils.Rd
man/connection.Rd
man/copy.Rd
man/cursor.Rd
man/format_for_send.Rd
man/misc.Rd
man/prepare.Rd
man/psql.Rd
man/query.Rd
man/rpg-package.Rd
man/stack.Rd
man/stow.Rd
man/table-info.Rd
man/table-io.Rd
man/tracing.Rd
man/transactions.Rd
src
src/Makevars.in
src/Makevars.win
src/RcppExports.cpp
src/config.guess
src/config.sub
src/install.sh
src/libpq
src/libpq/COPYRIGHT
src/libpq/Makefile.darwin
src/libpq/Makefile.global.darwin
src/libpq/Makefile.global.win32
src/libpq/Makefile.global.win64
src/libpq/Makefile.port.darwin
src/libpq/Makefile.shlib
src/libpq/Makefile.win
src/libpq/Makefile.win32
src/libpq/README
src/libpq/bcc32.mak
src/libpq/blibpqdll.def
src/libpq/c.h
src/libpq/chklocale.c
src/libpq/common
src/libpq/common/fe_memutils.h
src/libpq/crypt.c
src/libpq/encnames.c
src/libpq/exports.txt
src/libpq/fe-auth.c
src/libpq/fe-auth.h
src/libpq/fe-connect.c
src/libpq/fe-exec.c
src/libpq/fe-lobj.c
src/libpq/fe-misc.c
src/libpq/fe-print.c
src/libpq/fe-protocol2.c
src/libpq/fe-protocol3.c
src/libpq/fe-secure.c
src/libpq/getaddrinfo.c
src/libpq/getaddrinfo.h
src/libpq/inet_aton.c
src/libpq/inet_net_ntop.c
src/libpq/ip.c
src/libpq/libpq
src/libpq/libpq-dist.rc
src/libpq/libpq-events.c
src/libpq/libpq-events.h
src/libpq/libpq-fe.h
src/libpq/libpq-int.h
src/libpq/libpq.rc
src/libpq/libpq.rc.in
src/libpq/libpq/auth.h
src/libpq/libpq/be-fsstubs.h
src/libpq/libpq/crypt.h
src/libpq/libpq/hba.h
src/libpq/libpq/ip.h
src/libpq/libpq/libpq-be.h
src/libpq/libpq/libpq-fs.h
src/libpq/libpq/libpq.h
src/libpq/libpq/md5.h
src/libpq/libpq/pqcomm.h
src/libpq/libpq/pqformat.h
src/libpq/libpq/pqsignal.h
src/libpq/libpqddll.def
src/libpq/libpqdll.def
src/libpq/mb
src/libpq/mb/pg_wchar.h
src/libpq/md5.c
src/libpq/nls.mk
src/libpq/noblock.c
src/libpq/open.c
src/libpq/pg_config.h.darwin
src/libpq/pg_config.h.win
src/libpq/pg_config_ext.h
src/libpq/pg_config_manual.h
src/libpq/pg_config_os.h.darwin
src/libpq/pg_config_os.h.win
src/libpq/pg_config_paths.h
src/libpq/pg_config_paths.h.darwin
src/libpq/pg_config_paths.h.win
src/libpq/pg_service.conf.sample
src/libpq/pgsleep.c
src/libpq/pgstrcasecmp.c
src/libpq/port.h
src/libpq/postgres_ext.h
src/libpq/postgres_fe.h
src/libpq/pqexpbuffer.c
src/libpq/pqexpbuffer.h
src/libpq/pqsignal.c
src/libpq/pqsignal.h
src/libpq/pthread-win32.c
src/libpq/pthread-win32.h
src/libpq/snprintf.c
src/libpq/strlcpy.c
src/libpq/thread.c
src/libpq/utils
src/libpq/utils/palloc.h
src/libpq/wchar.c
src/libpq/win32.c
src/libpq/win32.h
src/libpq/win32.mak
src/libpq/win32error.c
src/libpq/win32setlocale.c
src/libpq/wininclude
src/libpq/wininclude/arpa
src/libpq/wininclude/arpa/inet.h
src/libpq/wininclude/netdb.h
src/libpq/wininclude/netinet
src/libpq/wininclude/netinet/in.h
src/libpq/wininclude/pwd.h
src/libpq/wininclude/sys
src/libpq/wininclude/sys/socket.h
src/libpq/wininclude/sys/wait.h
src/rpg.cpp
src/rpg.h
rpg documentation built on May 21, 2017, 2:19 a.m.

Questions? Problems? Suggestions? Tweet to @rdrrHQ or email at ian@mutexlabs.com.

Please suggest features or report bugs in the GitHub issue tracker.

All documentation is copyright its authors; we didn't write any of that.