postgres add prefix to primary key
CREATE TRIGGER test BEFORE INSERT ON name_of_table FOR EACH ROW SET row_nanme = CONCAT('prefix-', primary_key);
CREATE TRIGGER test BEFORE INSERT ON name_of_table FOR EACH ROW SET row_nanme = CONCAT('prefix-', primary_key);