0

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
  • 5,437
  • 5
  • 29
  • 55
user7270166
  • 29

1 Answers1

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.

Scarabee
  • 5,437
  • 5
  • 29
  • 55