dbtbls: dbtbls Searches the databases and schema

In DyfanJones/connectR: Database backend for DBI, dplyr and dbplyr

Description

Searches the databases and schema and returns creator's name

Usage

dbtbls(conn, db = NULL, schema = NULL, query = FALSE)

Arguments

conn:	Connection to database. Can used assigned output from function connectR for the connection.
db:	Database name i.e. default
schema:	Database schema i.e public

Value

Returns all tables from the database.

Examples

 #Search for default user (account signed into the computer)
  tables in the database default.
   dbtbls(post)->dbtables

 #Search for default user (account signed into the computer)
  tables in the database c("postgres","postgres1"), also searches for schema public.
   dbtbls(post,db=c("postgres","postgres1"),schema="public")->dbtables

DyfanJones/connectR documentation built on May 23, 2019, 10:32 p.m.