List names of all columns in a postgres table

List names of all columns in a postgres table

Usage

fpr_dbq_lscols(schema = "bcfishpass", table = "crossings_vw", ...)

Arguments

schema

Character string (quoted) name of target postgres db schema. See names of schemas with fpr_dbq_lstables

table

Character string (quoted) name of target postgres db table See names of schemas with fpr_dbq_lstables

Value

tibble of columns names and associated type for specified table.

See also

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

Examples

if (FALSE) fpr_db_query(query = fpr_dbq_lscols())