[R-sig-DB] RPostgreSQL - dbWriteTable

[Chris Long]

What's the best way to coax RPostgreSQL into writing a table to a
schema other than "public"? I've tried dbWriteTable("schema.foo",data),
setting search_path to "schema" etc. Nothing's worked; it's either
create "foo" in public, or the table "schema.foo" in public (!).
It will also refuse to write the table if it exists in any schema (!).

Using Ubuntu 10.10 64-bit,
'http://cran.stat.ucla.edu/src/contrib/RPostgreSQL_0.1-7.tar.gz'
R version 2.12.2 (2011-02-25)
-- 
Chris Long, San Diego Padres, 100 Park Boulevard, San Diego CA

WARNING - HIGH SPIN SPEEDS - DO NOT put any person in this washer.

	[[alternative HTML version deleted]]