1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
|
# PostgreSQL
## Install
First install PostgreSQL, create a data directory, and create a default database.
```
brew install postgresql
export PGDATA=~/db/postgres-9.5 # set this globally somewhere
initdb -E utf8
createdb
createdb hadley
createdb test
createdb lahman
createdb nycflights13
```
## Start
```
pg_ctl start
```
## Connect
```{r, eval = FALSE}
install.packages("RPostgreSQL")
library(DBI)
con <- dbConnect(RPostgreSQL::PostgreSQL(), dbname = "hadley")
dbListTables(con)
```
|
