makeDBcolsText: Set columns in database table to text.

In paulhegedus/OFPE: On-Farm Precision Experiments (OFPE) Data Management and Analysis Tools

Set columns in database table to text.

Description

Set column data type in PostgreSQL database to text for storage. This is done after data import.

Usage

makeDBcolsText(db, dat_names, schema, dtype)

Arguments

db	Database connection to OFPE formatted database.
dat_names	Names of columns in data that was imported to the database that are converted to a text data format in the database.
schema	Name of the schema with the table to convert columns to text in.
dtype	The name of the table in the schema to convert the column names to text for.

Value

Columns in database table set to text data type.

paulhegedus/OFPE documentation built on Nov. 23, 2022, 5:09 a.m.