Cannot use DBI::dbWriteTable to save temporary table to Redshift

[ghost]

When trying to write a simple temporary table to Redshift, I run into an error.

connection <- DBI::dbConnect(drv = RPostgres::Postgres(), 
                             host = host, 
                             port = port, 
                             dbname = dbname, 
                             user = user, 
                             password = password)
DBI::dbWriteTable(conn = connection, name = "iris", value = iris)

Any idea what could be causing this issue? A similar code (substituting name by DBI::Id(schema, table)) works fine for writing permanent tables.

[krlmlr]

Thanks. Can you try RPostgres::Redshift() instead of RPostgres::Postgres() ?

[ghost]

It works using Redshift instead of Postgres. Thanks for helping @krlmlr.