Alter Table - PostgreSQL

ALTER TABLE temp_urut
ADD NO_URUT INTEGER;

-- ubah type data field
alter table temp_urut
ALTER COLUMN no_urut TYPE varchar(16);

--- add
alter table zz_mbpr_hist
add COLUMN lastupdate TIMESTAMP,
add COLUMN aksi varchar,
add COLUMN hostname VARCHAR,
add COLUMN username VARCHAR;

-- drop
alter table zz_mbpr_hist
drop COLUMN lastupdate,
drop COLUMN aksi,
drop COLUMN hostname,
drop COLUMN username;

-- add constraint
ALTER TABLE kategori2 ADD CONSTRAINT kategori_pk2 PRIMARY KEY (masterkey);

-- Add PK
ALTER TABLE m_sandi_mapping
    ADD CONSTRAINT fk_acc_account_number FOREIGN KEY (id_akun_ebpr) REFERENCES acc_account_number (id);