dbi.catalog: Create a 'dbi.catalog'

In dbi.table: Database Queries Using 'data.table' Syntax

Create a dbi.catalog

Description

A dbi.catalog represents a database catalog.

Usage

dbi.catalog(conn, schemas)

Arguments

conn	a connection handle returned by dbConnect or a zero-argument function that returns a connection handle.
schemas	a character vector of distinct schema names. These schemas will be loaded into the dbi.catalog. By default (when schemas is missing), dbi.catalog loads all available schemas.

Value

a dbi.catalog.

Examples

# chinook.duckdb is a zero-argument function that returns a DBI handle
(db <- dbi.catalog(chinook.duckdb))

# list schemas
ls(db)

# list the tables in the schema 'main'
ls(db$main)

dbi.table documentation built on June 29, 2025, 1:07 a.m.