Displaying 1 result from an estimated 1 matches for "queryfile".
Did you mean:
curryfile
2005 Sep 14
1
maximum string length in RdbiPgSQL and in R
...y
save my queries in text files that I can use either in PostgreSQL's psql
(useful for testing and editing) or in R using readLines(). For example
(in R):
library(RdbiPgSQL)
conn <- dbConnect(PgSQL(), host = "localhost", dbname = "agdb")
test.sql < readLines("queryfile")
test.df <- dbGetQuery(conn, paste(test.sql, collapse = " "))
This works fine for all the multiline files I have tried -- except one.
I have recently encountered a problem with a moderately complex,
moderately long query (12 lines, 459 characters). I can execute the
query wit...