pg_summary: Creates a summary table from PostgreSQL table's columns

In jjesusfilho/rpsql: Psql Meta Commands From R

Description

Creates a summary table from PostgreSQL table's columns

Usage

pg_summary(
  conn,
  tbl,
  ...,
  schema = "public",
  max_levels = 10,
  outliers = FALSE
)

Arguments

conn	Connection
tbl	Table name
...	Columns' bare-names
schema	Schema name, "public" by default
max_levels	Max number of levels to report for categorical
outliers	Calculate outlier for numeric data? Defaults to FALSE.

Details

R exports factors as text to PostgreSQL, even though PostgreSQL has enum type which is somehow equivalent to factors. This function shows unique values as variable levels to maximum number of 10, unless otherwise specified. As of now, it f supports only dates, texts and numbers.

Value

Dataframe

jjesusfilho/rpsql documentation built on Aug. 9, 2021, 7:33 p.m.