Using RPostgreSQL to list the databases

Question

I am looking for an R command to list the available databases in a PostgreSQL server. I am using RPostgreSQL package in R.

I know how to connect to the server but the only thing I need to know is how to list the names of available databases.

Scarabee · Accepted Answer · 2016-12-13 09:57:06Z

6

Once you're connected to the server you can use this query:

dbGetQuery(con, "SELECT datname FROM pg_database WHERE datistemplate = FALSE")

con is the name of your connection.

answered Dec 13, 2016 at 9:57

Scarabee

5,7545 gold badges32 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1