ADBC PostgreSQL Driver

ADBC PostgreSQL Driver

Usage

adbcpostgresql()

# S3 method for class 'adbcpostgresql_driver_postgresql'
adbc_database_init(driver, ..., uri)

# S3 method for class 'adbcpostgresql_database'
adbc_connection_init(database, ..., adbc.connection.autocommit = NULL)

# S3 method for class 'adbcpostgresql_connection'
adbc_statement_init(
  connection,
  ...,
  adbc.ingest.target_table = NULL,
  adbc.ingest.target_db_schema = NULL,
  adbc.ingest.mode = NULL
)

Arguments

driver

The driver to use. This can be one of the following:

• A non-missing character(1) containing a driver or manifest name, a relative or absolute path to a driver or manifest, or a URI. For a URI, the driver manager uses the URI scheme as the driver name and passes the URI to that driver. A profile:// URI loads a connection profile.

• NULL, which leaves driver selection to the driver manager. In this case, ... must normally contain uri or profile; the driver is inferred from the URI or loaded from the connection profile.

• An object that inherits from the adbc_driver class, such as one created by adbc_driver(). This includes drivers provided by R packages, such as adbcsqlite::adbcsqlite().

...

Driver-specific options. These are generally named values that are converted to strings.

uri

A URI to a database path (e.g., postgresql://localhost:1234/postgres?user=user&password=password)

database

An adbc_database.

adbc.connection.autocommit

Use FALSE to disable the default autocommit behaviour.

connection

An adbc_connection

adbc.ingest.target_table

The name of the target table for a bulk insert.

adbc.ingest.target_db_schema

The schema of the table for a bulk insert.

adbc.ingest.mode

Whether to create (the default) or append.

Value

An adbcdrivermanager::adbc_driver()

Examples

adbcpostgresql()
#> <adbcpostgresql_driver_postgresql> List of 4
#>  $ load_flags      : int 15
#>  $ driver_init_func:Class 'adbc_driver_init_func' <externalptr> 
#>  $ .child_count    : int 0
#>  $ version         : int 1001000