pg_alterColumnType: Helper command to alter a column's data type via ALTER TABLE.

In pgTools: Functions for Generating PostgreSQL Statements/Scripts

Helper command to alter a column's data type via ALTER TABLE.

Description

Helper command to alter a column's data type via ALTER TABLE.

Usage

pg_alterColumnType(column_name, data_type, using = NULL)

Arguments

column_name	A string, the name of the column to add.
data_type	A string, the data type of the column to add.
using	A string, a command to cast the column into the appropriate type.

Value

A string, PostgreSQL helper statement to alter a column type using ALTER TABLE.

Examples

pg_alterColumnType(
column_name = "newCol",
data_type = "text"
)

pgTools documentation built on March 31, 2023, 7:56 p.m.