R读取Greenplum database数据

1
install.packages("RPostgreSQL")

1
2
3
4
5
6
7
8
9
10

library(RPostgreSQL)

con <- dbConnect(PostgreSQL(), host = "10.2.28.234", port = 5432, user= "fitl", password="xxxx", dbname="fitl")

rs <- dbGetQuery(con,"select windcode, code, market, cnname, enname, type from hffd.tdb_codes")

head(rs, n=10L)

dbDisconnect(con)