Learn R Programming

podr (version 0.0.5)

get_table_names: Get Table Names from PODR

Description

This function will get a list of table names from "PODR".

Usage

get_table_names(
  con = getOption("podr_connection"),
  query_string = NULL,
  lib_sel = NULL,
  ds_sel = NULL
)

Arguments

con

The connection to PODR. Use connect_podr to establish a connection, or specify a variable containing the proper PostgreSQL connection into PODR yourself

query_string

provides full SQL statement

lib_sel

Library name selection pattern

ds_sel

Dataset name selection pattern

Value

The selected table names in a data.frame

Examples

Run this code
# NOT RUN {
cc <- conn_podr()
get_table_names(con=cc)
get_table_names(query_string = "select * from information_schema.tables")
get_table_names(query_string = "select * from information_schema.tables", lib_sel = "readme")
# }
# NOT RUN {
# }

Run the code above in your browser using DataLab