get_table_names: Get Table Names from PODR

In TuCai/podr: Common Functions for 'PHUSE' Open Data Repository

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

Author(s)

Hanming Tu

Examples

## 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")

## End(Not run)

TuCai/podr documentation built on June 8, 2021, 5:37 a.m.