Hi,
dbSendQuery(conn, "SET search_path = myschema;") dbGetQuery(conn, "SHOW search_path")
because the search_path only applies to the current session, and the session ends when dbSendQuery returns a result.
This is something different from my understanding. dbSendQuery just sends query and does not end the session. On the contrary, it leaves the connection open and in an unfinished state, and the second dbGetQuery will open a new connection, so that you get
search_path 1 "$user",public
So, please instead try dbGetQuery(conn, "SET search_path = myschema") dbGetQuery(conn, "SHOW search_path")
So is there a way to write to anything other than the public schema in version 0.1-7?
To my understanding, dbGetQuery(conn, "SET search_path = myschema") dbWriteTable(conn, "table_name", ...) will write the dataframe to myschema.table_name
Tomoaki NISHIYAMA Advanced Science Research Center, Kanazawa University, 13-1 Takara-machi, Kanazawa, 920-0934, Japan