4

I'm connecting and querying a PostgreSQL database through the dplyr package in R. I know I can list all the tables in the database using dbListTables(con). But, my tables are organized into different schema. What is the easiest way I can view all of the schema that are present in my database using R?

m0nhawk
  • 22,980
  • 9
  • 45
  • 73
T. Shiftlet
  • 158
  • 13

1 Answers1

6

dbGetQuery(con, "SELECT nspname FROM pg_catalog.pg_namespace")

T. Shiftlet
  • 158
  • 13