Skip to main content

R Studio + Panoply

Comments

4 comments

  • Matan

    Hi there,
    What seems to be the error you are running into?

    0
  • Skyler

    I’ve had success using the RPostgresSQL package. The syntax to connect to your db would look something like this, but you would need to replace the placeholders in single quotes with the information found in the connection details within Panoply…

    install.packages(“RPostgreSQL”)
    library(RPostgreSQL)
    drv <- dbDriver(“PostgreSQL”)
    samplecon <- dbConnect(drv,
    host = ‘host’,
    port = ‘port’,
    user = ‘user’,
    password = ‘password’,
    dbname = ‘dbname’)
    sampledf = dbReadTable(samplecon, ‘tablename’)

    0
  • mmorganfield

    Thanks Skyler and Matan,

    I think my current issue is working with the drivers and DSN outside user permissions on my work comp. I’ll try again today from an admin to try and troubleshoot from there.

    0
  • mmorganfield

    Wrapping this up, just had a small syntax issue that I fixed and everything is good to go! Thanks for the input all.

    dbConnect(RPostgreSQL::PostgreSQL(),
    dbname = “name”,
    host = “host”,
    port = port,
    user = “user”,
    password = “pass”)

    0

Please sign in to leave a comment.

Powered by Zendesk