Displaying 1 result from an estimated 1 matches for "pgsqldrv".
Did you mean:
pgsqldb
2008 Nov 28
0
Passing bigint (8-byte) values from Postgres to R using RPostgreSQL
...600000100000). However, the value returned in R is different
(specifically 2007111600000100096). For every bigint value, the value
returned is the value generated by the database + 96.
An example of the code to obtain the value from the database is as follows:
------------------------------------
PgSQLdrv <- dbDriver("PostgreSQL")
con <-
dbConnect(PgSQLdrv,host="localhost",dbname="MyDB",user="user",password="password",port=5432)
rs <- dbSendQuery(con,statement = paste('SELECT "UID" FROM "mytable" LIMIT
1',sep=...