dbc_list_tables: List tables in a database

In dgrtwo/dbcooper: Access Databases Through Autogenerated Functions

List tables in a database

Description

dbListTables doesn't work for all types of databases, especially ones that have schemas. We use this approach instead. Work in progress as we test across different database types.

Usage

dbc_list_tables(con, exclude_schemas)

## Default S3 method:
dbc_list_tables(con, exclude_schemas = c("information_schema", "pg_catalog"))

## S3 method for class 'PqConnection'
dbc_list_tables(con, exclude_schemas = c("information_schema", "pg_catalog"))

## S3 method for class 'Snowflake'
dbc_list_tables(con, exclude_schemas = c("INFORMATION_SCHEMA"))

## S3 method for class 'SnowflakeDBConnection'
dbc_list_tables(con, exclude_schemas = c("INFORMATION_SCHEMA"))

## S3 method for class 'duckdb_connection'
dbc_list_tables(con, exclude_schemas = c("INFORMATION_SCHEMA"))

Arguments

con	A connection or pool object
exclude_schemas	Schemas for which no tables should be returned. The default excludes information_schema and pg_catalog, which typically contain database metadata.

dgrtwo/dbcooper documentation built on Nov. 18, 2023, 6:24 p.m.