Connect to Postgres via SSL using R

by

https://github.com/r-dbi/RPostgres seems to be the more modern and maintained package at this point. This is what worked for me…

install.packages("RPostgres")
require(RPostgres)

db = dbConnect(
  Postgres(), 
  user="user",
  password = 'password',
  dbname="dbname",
  host="host",
  port = port,
  sslmode="require"
)

dbListTables(db)

More Related Contents:

  1. How to resolve “invalid number of 'breaks'” [closed]
  2. Calculate gradient of data in R (or other) [closed]
  3. Dynamically select data frame columns using $ and a character value
  4. Controlling number of decimal digits in print output in R
  5. Offline install of R package and dependencies
  6. How to save plots that are made in a shiny app
  7. ggplot2 change axis limits for each individual facet panel
  8. Confusion between factor levels and factor labels
  9. ggplot plots in scripts do not display in Rstudio
  10. What’s the best way to use R scripts on the command line (terminal)?
  11. General suggestions for debugging in R
  12. ignore NA in dplyr row sum
  13. Creating dummy variables in R data.table
  14. Can’t print to pdf ggplot charts [duplicate]
  15. Multiline Comment Workarounds?
  16. How do I change the background color of a plot made with ggplot2
  17. What is the difference between gc() and rm()
  18. How to change the figure caption format in bookdown
  19. How to test if list element exists?
  20. Returning first row of group
  21. How to split a data frame into multiple dataframes with each two columns as a new dataframe?
  22. Merging two columns into one in R [duplicate]
  23. What is difference between dataframe and list in R?
  24. Simple approach to assigning clusters for new data after k-means clustering
  25. How to save() with a particular variable name
  26. R – How to make a click on webpage using rvest or rcurl
  27. ggplot embedded fonts in pdf
  28. How to properly document S4 methods using roxygen2
  29. Formatting a date in R without leading zeros
  30. Chronological timeline with points in time and format date

Leave a Comment