issue on data import to pgAdminIII

[player]

Hi

I trying to use the function dbWriteTable to write data from R into
pgAdminIII

The table is called price and the column within in price is called
pricelevel

The connection works fine and when I call dbExistsTable(con, "price") I get
true so, so far so good.

However, when I call the function as

dbWriteTable(con, name="price", value=df,
field.types=list(pricelevel=double(20)), row.names=FALSE)

I get the error

Error in function (classes, fdef, mtable)  :
  unable to find an inherited method for function "dbWriteTable", for
signature "PostgreSQLConnection", "character", "missing"

Any idea on what I'm doing wrong?

The version of R is 2.13.1

Regards

Krisan

        [[alternative HTML version deleted]]

_______________________________________________
[hidden email] mailing list
https://stat.ethz.ch/mailman/listinfo/r-sig-finance
-- Subscriber-posting only. If you want to post, subscribe first.
-- Also note that this is not the r-help list where general R questions should go.

[braverock]

On Wed, 2012-05-02 at 09:46 +0100, krisan haria wrote:
>
> I trying to use the function dbWriteTable to write data from R into
> pgAdminIII
>
> The table is called price and the column within in price is called
> pricelevel

While you may be trying to use the database to do finance, this question
has nothing to do with finance.

> Any idea on what I'm doing wrong?

1> you posted to the wrong mailing list.
R-SIG-DB or R-Help would have been more appropriate.

2> You did not follow the Posting guide:
http://www.r-project.org/posting-guide.html

3> (sub of 2)  you did not provide a minimal reproducible example

> The version of R is 2.13.1

4> you're using a very old version of R

--
Brian G. Peterson
http://braverock.com/brian/
Ph: 773-459-4973
IM: bgpbraverock

_______________________________________________
[hidden email] mailing list
https://stat.ethz.ch/mailman/listinfo/r-sig-finance
-- Subscriber-posting only. If you want to post, subscribe first.
-- Also note that this is not the r-help list where general R questions should go.