RPostgreSQL driver timestamp data type mapping

Hi,

Using the RPostgreSQL driver to access a view on a PostgreSQL 8.4
database:

library(RPostgreSQL)
m <- dbDriver("PostgreSQL")
con <- dbConnect(m, user="me", password="pwd", dbname="dbname")
qry <- "SELECT * FROM mytable"
rs <- dbSendQuery(con, qry)

Fields corresponding to timestamp data type are mapped to POSIXct, as
shown by dbColumnInfo():

       name    Sclass      type len precision scale nullOK
...
...
8  date_time   POSIXct TIMESTAMP   8        -1    -1   TRUE

I'd like to have a bit more control over this conversion, as it
currently results in the POSIXct object having the time zone of my
locale,

x <- Sys.time()
x

attr(x, "tzone") <- "PST8DST"
x

attr(x, "tzone") <- NULL
x

whereas I need to set it to GMT.  Reading the DBI manual, I
can't see how this could be done.  Any pointers would be appreciated.
Thanks.


Cheers,

-- 
Seb

Not really: POSIXct times are absolute times: it is when they are
displayed that you see the locale.  So just add a tzone attribute to
the result, as in

x <- Sys.time()
x

[1] "2010-01-13 07:07:26 GMT"

attr(x, "tzone") <- "PST8DST"
x

[1] "2010-01-12 23:07:26 PST"

attr(x, "tzone") <- NULL
x

[1] "2010-01-13 07:07:26 GMT"