Answers for "how to add prefix number in postgres sql"

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);

Posted by: Guest on November-21-2020

Code answers related to "how to add prefix number in postgres sql"