xxxxxxxxxx
-- Note: any changes you do will be automatically updated in the database
-- Rename
ALTER TYPE electronic_mail RENAME TO email;
-- change onwner
ALTER TYPE email OWNER TO joe;
-- change schema
ALTER TYPE email SET SCHEMA customers;
-- add new attribute to compsite
ALTER TYPE compfoo ADD ATTRIBUTE f3 int;
-- add new enum value
ALTER TYPE colors ADD VALUE 'orange' AFTER 'red';
-- rename enum value
ALTER TYPE colors RENAME VALUE 'purple' TO 'mauve';
xxxxxxxxxx
https://www.postgresql.org/docs/current/sql-altertype.html
xxxxxxxxxx
ALTER TABLE table_name
ALTER COLUMN column_name [SET DATA] TYPE new_data_type;
xxxxxxxxxx
ALTER TABLE table_name
ALTER COLUMN column_name [SET DATA] TYPE new_data_type;
Code language: CSS (css)