R/showTables.R

In Kidapt/keda: A Package to Support Exploratory Data Analysis

#' shows a prespecified selection of tables for PostgreSQL and Redshift
#'
#' shows a prespecified selection of tables for PostgreSQL and Redshift
#' @param db is the database you want to see tables for
#' @keywords table database
#' @export
#' @examples
#' showTables(olap)

showTables = function(db){
  query(db,"select table_schema schm, table_name tbl, column_name colname, ordinal_position ord, column_default defval, is_nullable nullable, udt_name typ, character_maximum_length maxlen from information_schema.columns where table_schema not in ('pg_catalog','information_schema')")
}