PgCon: R6 Class PyCon postgresql connection.

In diegogarcilazo/pgr: Set of wrapper functions to work with PostgreSQL.

R6 Class PyCon postgresql connection.

Description

R6 Class PyCon postgresql connection.

R6 Class PyCon postgresql connection.

Methods

Public methods

• PgCon$new()

• PgCon$finalize()

• PgCon$print()

• PgCon$import()

• PgCon$export()

• PgCon$disconnect()

• PgCon$describeTable()

• PgCon$clone()

---

Method new()

Usage

PgCon$new(
  name,
  user = "postgres",
  host = "localhost",
  port = "5432",
  driver = RPostgres::Postgres(),
  client_encoding = "UTF8"
)

---

Method finalize()

Usage

PgCon$finalize()

---

Method print()

Usage

PgCon$print()

---

Method import()

Usage

PgCon$import(sql_obj)

---

Method export()

Usage

PgCon$export(
  df,
  schema = "public",
  table_name,
  overwrite = FALSE,
  append = FALSE,
  temporary = FALSE
)

---

Method disconnect()

Usage

PgCon$disconnect()

---

Method describeTable()

Usage

PgCon$describeTable(table_name)

---

Method clone()

The objects of this class are cloneable with this method.

Usage

PgCon$clone(deep = FALSE)

Arguments

deep

Whether to make a deep clone.

diegogarcilazo/pgr documentation built on Nov. 16, 2023, 6:24 p.m.