similar to: Data frame to PostgreSQL without primary key

Dear R User's Please help me to debug this issue. I am trying to write some data ( i= 6) to PostgreSQL database, but it not writing. Is there any issue in the way I use "dbWriteTable"? ++++++++++++++++++ Source Code ++++++++++++++++++++++++ library("DBI") library("RPostgreSQL") drv1 <- dbDriver("PostgreSQL") i=6 connAE1 <- dbConnect(drv1,host

Hello List, I would like to connect to a postgreSQL database on a remote server and I am wondering what is the best package to do that. I have just installed RpgSQL, RPostgreSQL, Rdbi and RODBC. The handiest to me is RPostgreSQL but I don't see how to connect to a remote server with it. For sure I can connect to remote server with RODBC, but since I am on a Mac OSX 10.6, I have quite

Hi Everyone, I'm currently using the latest build of R and R-Studio server (both are amazing products) I'm still very new to this but I came across this issue: I'm trying to do a select from postgres and put the data into and xts object like so: # Libs library('RPostgreSQL') # http://code.google.com/p/rpostgresql/ library('quantmod') library('TTR')

Dear R-helpers, I'm an absolute beginner using both R and PostgreSQL, but now I have to work with both programs. I need to connect R and my Postgres-database, but every attempt so far has failed (I tried using the RpgSQL package as well as RdbiPgSQL, the first, following this manual (http://code.google.com/p/rpostgresql/) didn't find any drivers for the database (step no. 1) whereas the

Hi Dirk I think there are problems with pg_config, the configure script of RPostgreSQL checks for pg_config and got ¡°checking for pg_config... /usr/bin/pg_config¡±. In Solaris 10u7 X64, three versions of PostgreSQL are installed, there are in /usr/postgres/8.2(8.2.9) and /usr/postgres/8.3(8.3.3), the corresponding bin files are in /usr/postgres/<version>/bin and

Hello, I am trying to install RPostgreSQL, but without success at the moment, getting an errormessage - see below. My OS is Fedora 17, R version 2.15.2, PostgreSQL 9.2.1 with Postgis 2.0.1 spatial extension. Thank You for any help, advice or hint in advance. Regards Tomas > install.packages("RPostgreSQL", dependencies=TRUE) trying URL

I am using RStudio Version1.0.143 on a Windows 7 machine. R version 3.4.0 I am trying to connect to a postgreSQL database with the following command, but I receive an error message that says my password is incorrect. Since I saved my password in a file, I think I remember it. I searched for a solution online, but cannot figure out what to do. If I have to change my password, please provide

Hi All, I have a R script which returns a set of records from the postgresql to the Java program and I want to print those records in Java.My script is like this: library(RPostgreSQL) fnct1 <- function() { drv <- dbDriver("PostgreSQL") r <- dbConnect(drv, host='local', port='1234',dbname='db', user='user',

Dear all, I'm an absolute R-beginner and want to connect to my PostgreSQL DB (on my local Mac OSX 10.6). 1) I tried to install RPostgreSQL (Package Installer > CRAN (sources)) and get this log below. There seems to be an issue with libpq, bug I don't have any clue how to fix this. What can I do? 2) Once this issue is solved, should this code work? drv <-

Dear all, i am trying to get PL / R running on Mac OS X. PostgreSQL is already running and connects just smoothly to R via DBI / RPostgreSQL . Despite finding a couple of posts of people with the same problem (i.e. error message) i could not get it done for me. I use Mac OS 10.5.7 and PostgreSQL 8.3.7 as well as R 2.9.2 I put the untared plr to my /Library/Frameworks/R.framework/Resources/

hello, if i load the RSQLite package in addition to the RPostgreSQL package, i get various errors when trying to use RPostgreSQL functions. here is an example transcript showing one such error: ========================================================== R version 2.15.0 (2012-03-30) [...] > packageVersion('RPostgreSQL') [1] 0.3.2 > packageVersion('RSQLite') [1] 0.11.1

Hi, I am getting the following error while trying to install RPostgreSQL. I tried all three methods(install.packages("RPostgreSQL", type = "source"),install.packages("RPostgreSQL") & R CMD INSTALL RPostgreSQL_0.3-1.tar.gz ) , but none of them is working. ++++++++++++++++++ Error++++++++++++++++++++++++ gcc -std=gnu99 -I/usr/share/R/include -DNDEBUG -I

Hi, I've just started using RPostgreSQL within R to interrogate a PostgreSQL database. The problem I have is that a column containing dates shows up differently in R than in the database: here is the output direct from the psql database in Linux: db=> select pat_dob_dt from patients where pat_dob_dt like '%1980'; pat_dob_dt ------------ 04/05/1980 01/12/1980 04/05/1980

I'm starting to seriously use R and have tried to solve this issue using my reference books but I'm missing something simple. Running R-2.13.1 on Slackware-13.1. Trying to invoke RPostgreSQL so I can copy data from a postgres table to an R data-frame. I installed RPostgreSQL and the library() command shows it's present: Packages in library

Dear list users, The problem occurs when library(RPostgreSQL) is issued on R. This issue has previously appeared on R mailing list without any robust solution. The error message issued by R: Loading required package: RPostgreSQL Loading required package: DBI Error in inDL(x, as.logical(local), as.logical(now), ...) : unable to load shared library

A question, please about development of R packages: Are there any guidelines or best practices for deciding when and why to implement an operation in R, vs. implementing it in C? The "Writing R Extensions" recommends "working in interpreted R code . . . this is normally the best option." But we do write C-functions and access them in R - the question is, when/why is this

Hi, I recently upgraded to R 2.9.0 on linux x86. After doing so, I switched to the RPostgreSQL package for interfacing with a postgresql database. I am using postgresql 8.3.7. A query that works from the postgresql terminal is causing a segfault when executed from R. My sessionInfo, the error message, and the R code used to generate the error are listed below. I have noticed that a

RPostgreSQL version 0.1.0 We are pround to announce the availability of the RPostgreSQL package on CRAN and its mirrors. This package provides an a DBI-compliant interface between PostgreSQL and R. RPostgreSQL was developed as part of the Google Summer of Code 2008 program by Sameer Kumar Prayaga. Some highlights: o Implemented all the DBI features o Added support for transaction

RPostgreSQL version 0.1.0 We are pround to announce the availability of the RPostgreSQL package on CRAN and its mirrors. This package provides an a DBI-compliant interface between PostgreSQL and R. RPostgreSQL was developed as part of the Google Summer of Code 2008 program by Sameer Kumar Prayaga. Some highlights: o Implemented all the DBI features o Added support for transaction

Hi, I have a sequence set up on one of my tables called seq_user_mytable. I tried the following with no joy: set_primary_key "user_id", :sequence => "seq_user_mytable" and: ActiveRecord::Base.seq_user_mytable again with no joy. How do I implement a sequence in Rails/ActiveRecord? -- Regards Andrew --~--~---------~--~----~------------~-------~--~----~ You received this