How to write to database schema other than public using RPostgreSQL
It seems dbWriteTable always create table in the public schema even if I put the target schema as the header of search_path, I'll check the source code.
On Sat, Mar 5, 2011 at 8:32 PM, Xiaobo Gu <guxiaobo1982 at gmail.com> wrote:
Hi, It seems there is not a shcema parameter for method dbWriteTable, and I have tried "[schema].[testtable]", "\"schema\".\"testtable\", "schema.testtable" for the tablename parameter of dbWriteTable, none of them works. Do you have workarounds about this. Thanks, Xiaobo Gu