metastore.change_column_type) #Required privileges: Postgres Pro AXE administrator only. For more information about stored procedures and privileges, refer to Section 22.1.
Execute the following command:
SELECT metastore.change_column_type('table_name', 'column_name', 'new_data_type');
Where:
table_name: The name of the
analytical table that contains the column.
It can be specified as a fully qualified name in the
schema_name.table_name
format, or as just the table name. If you do not specify the analytical
schema name, the current schema is used.
column_name: The name of the column whose
data type is changed.
new_data_type: The new data type
of the column.
For more information about supported data types, refer to Section F.3.
Postgres Pro AXE performs the following actions:
Verifies input parameters and user privileges.
Ensures that the new column data type does not match the previous one.
Ensures that the analytical table is empty or that the new data type is compatible with the previous one:
int8 can be changed to int16,
int32, or int64
int16 can be changed to int32 or
int64
int32 can be changed to int64
uint8 can be changed to uint16,
uint32, or uint64
uint16 can be changed to uint32 or
uint64
uint32 can be changed to uint64
float32 can be changed to float64
Updates the column_type value for the column
in the pga_column
metadata table.
Updates the view_sql value for the analytical
table.
Example 26.3. Executing the metastore.change_column_type stored procedure
SELECT metastore.change_column_type('testtable', 'third_col', 'uint8');