get_database_names: Get a list of all databases

View source: R/pmap_db_utilities.R

get_database_namesR Documentation

Get a list of all databases

Description

This function will connect to "master", and thus does require at least username or trusted=F and will return a list of all db objects, that subsequently might be passed to db_name of the get_sql_connection function

Usage

get_database_names(pattern = NULL, ...)

Arguments

pattern

a regular expression to limit searching for dbnames

...

passed to get_sql_connection()

Value

a tibble of database names, id, create_dates for the databases found at the connection to the server as dictated by ... passed to get_sql_connection()

Examples

get_database_names(trusted=T)
get_database_names(username="<jhed_id>")
get_database_names(username="<jhed_id>", pattern="(?i)covid")

lmullany/pmap_utilities documentation built on July 30, 2023, 8:54 a.m.