Get information on tables in a schema (or two)

library(RPostgreSQL)
drv <- dbDriver("PostgreSQL")
pg <- dbConnect(drv, dbname="crsp") 

dbGetQuery(pg, "
  SELECT table_schema, table_name, ordinal_position, column_name, data_type 
  FROM information_schema.columns 
  WHERE table_schema IN ('board', 'executive')
  ORDER BY table_schema, table_name, ordinal_position")

dbDisconnect(pg)
Advertisements
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s