I know this isn't the proper use for this package, but RPostgres works perfectly for a JBoss Data Virtualization Layer on top of an Amazon Redshift data warehouse. My team has been using it for over a year now. The only issue is that I had to fork the repo and comment out:
dbExecute(con, "SET TIMEZONE='UTC'")

in PqConnection.R because that's not a valid command in JBoss DV. Is there any way you could add a parameter for RPostgres() to allow for not running that command?

Thanks for considering!