RODBC.R

#install.packages("RODBC")
library(RODBC)
odbcDataSources()

##                                              dBASE Files 
##    "Microsoft Access dBASE Driver (*.dbf, *.ndx, *.mdx)" 
##                                              Excel Files 
## "Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)" 
##                                       MS Access Database 
##               "Microsoft Access Driver (*.mdb, *.accdb)" 
##                                             PostgreSQL30 
##                           "PostgreSQL ODBC Driver(ANSI)"

#creating a Database connection
# for username,password,database name and DSN name

chan=odbcConnect("PostgreSQL30","postgres;Password=root;Database=ajay")

#to list all table names
sqlTables(chan)

##   TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE REMARKS
## 1      ajay      public      sales      TABLE

sqlFetch(chan,"sales",max=10)

##    customer_id sales       date product_id
## 1        10001  5230 2017-02-07        524
## 2        10002  2781 2017-05-12        469
## 3        10003  2083 2016-12-18        917
## 4        10004   214 2015-01-19        354
## 5        10005  9407 2016-09-26        292
## 6        10006  4705 2015-10-17        380
## 7        10007  4729 2016-01-02        469
## 8        10008  7715 2015-09-12        480
## 9        10009  9898 2015-04-05        611
## 10       10010  5797 2015-08-13        959