[R/COMMON] PostgreSQL 데이터베이스 사용하기

icodebroker COMMON 2024-06-18

■ PostgreSQL 데이터베이스를 사용하는 방법을 보여준다.

▶ 예제 코드 (R)


install.packages("DBI")
install.packages("RPostgreSQL")

library(DBI)
library(RPostgreSQL)

driver<-dbDriver("PostgreSQL")

connection<-dbConnect(drviver, host = "127.0.0.1", port = "5432", dbname = "postgres", user = "postgres", password = "1234")

recordSet<-dbSendQuery(connection, "select * from testr")

fetch(recordSet, n = -1)

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

install.packages("DBI")

install.packages("RPostgreSQL")

library(DBI)

library(RPostgreSQL)

driver<-dbDriver("PostgreSQL")

connection<-dbConnect(drviver, host = "127.0.0.1", port = "5432", dbname = "postgres", user = "postgres", password = "1234")

recordSet<-dbSendQuery(connection, "select * from testr")

fetch(recordSet, n = -1)