dbpf_table_columns: Return all column names from a table

In geocryology/PermafrostDB: PermafrostDB

Return all column names from a table

Description

Return all columns from a table within the permafrost database @ Carleton University

Usage

dbpf_table_columns(con, tablename, detailed = F)

Arguments

con	Database connection object, as returned by dbpf_con
tablename	Name of the table for which to retrieve field names
detailed	logical, whether or not to return a list of all column information or just names. Default to false.

Details

These simple functions return all data as data frames. When making a query many times, optimise the SQL statement to only request the data you actually need.

Value

List of columns in the DB table

Author(s)

Nick Brown <[e-mail]>

Examples

## Not run: 
location_cols <- dbpf_table_columns('locations')

## End(Not run)

geocryology/PermafrostDB documentation built on April 17, 2025, 11:54 a.m.