[R-sig-DB] How to write to database schema other than public using RPostgreSQL

[Xiaobo Gu]

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 using 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
>