```r
# knitr::opts_chunk$set(echo = TRUE,eval=FALSE)
# ## Command commented out, as there is no need to run it again
# system("PGPASSWORD=!SECRET! dropdb -U !SECRET! -h postgis gis_course")
# 
# system("PGPASSWORD=!SECRET! createdb -U !SECRET! -h postgis --template=template_postgis gis_course") 
# #system("PGPASSWORD=!SECRET! pg_dump -h postgis -U !SECRET! gis_course | PGPASSWORD=!SECRET! psql -h postgis -U !SECRET! -d gis_course2") ### I messed up on the encoding by not setting the template ## Trying a fix by pipiing into a new data base
```