List all tables and their sizes

List all tables and their sizes

Usage

fpr_dbq_lstables(col_order = "table_schema, table_name")

Arguments

col_order

A single quoted character string with columns to order results on. Default is 'table_schema, table_name'. To order by size descending use 'size desc'.

Value

tibble with schema name, table name and sizes of all tables in database.

See also

Other database postgres: fpr_db_conn(), fpr_db_query(), fpr_dbq_clip(), fpr_dbq_lscols(), fpr_dbq_subset()

Examples

if (FALSE) {
fpr_db_query(fpr_dbq_lstables(col_order = 'size desc'))
}