Answers for "postgresql update type"

SQL
6

postgresql add enum value

ALTER TYPE enum_type ADD VALUE 'new_value'; -- appends to list
ALTER TYPE enum_type ADD VALUE 'new_value' BEFORE 'old_value';
ALTER TYPE enum_type ADD VALUE 'new_value' AFTER 'old_value';
Posted by: Guest on March-22-2020
2

update column data type postgres

ALTER TABLE table_name
ALTER COLUMN column_name [SET DATA] TYPE new_data_type;
 
Posted by: Guest on April-03-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language