Top "Rpostgresql" questions

An R interface to the PostgreSQL database system

Install RPostgreSQL on RHEL 6.5 libpq-fe.h Error

I have RHEL 6.5 Server with an installation of R (3.1.1) & RStudioServer (0.98.1062) I have postgresql-9.3 installed and handling a large database. …

r postgresql rpostgresql
How to use column defaults with dbWriteTable(..., append=TRUE) in RPostgreSQL

The dbWriteTable function in RPostgreSQL seems to ignore column names and tries to push data from R to PostgreSQL as-is. …

r postgresql rpostgresql
RPostgreSQL Cannot Close Connections

I have a shiny app that connects to a database using RPostgreSQL. At the end of the app the connection …

r rpostgresql
Using sqldf and RPostgreSQL together

When using RPostgreSQL I find that I cannot use sqldf in the same way. For example if I load the …

sql r postgresql sqldf rpostgresql
UTF-8 / Unicode Text Encoding with RPostgreSQL

I'm running R on a Windows machine which is directly linked to a PostgreSQL database. I'm not using RODBC. My …

r postgresql encoding utf-8 rpostgresql
Installing RPostgreSQL on Linux

When I try on linux in R install.packages('RPostgreSQL') it fails with unspecified errors: Warning message: In install.packages("…

linux installation rpostgresql