sql.attributes: Table list and simple metadata extraction

In cezden/rpostgrexplorer: Simplification of analysis in PostgreSQL and Redshift DBs

Description

Constructs the query retrieving the metadata information of each attribute in each table as well as statistics computed by PostreSQL:

• schemaname

• tablename

• attribute name

• type of attribute

• length of attribute (related to type)

• estimated fraction of NULL values

• estimated number of distinct values (caution!)

• most common values

• frequency of most common values

• histogram bounds

Usage

sql.attributes(schemaname = NULL)

Arguments

schemaname

name of specific schema, if not provided tables from all schemas will be returned

cezden/rpostgrexplorer documentation built on May 13, 2019, 3:08 p.m.