reading from posgresql

I don't know how to read data from posgresql to R.

The RdbiPgSQL package will read from Postgres.  Its current incarnation is
available via Bioconductor (www.bioconductor.org).