codekingpro/portable-devtools

1DROP TABLE username_test;2 3CREATE TABLE username_test (4	name		text,5	username	text not null6);7 8CREATE TRIGGER insert_usernames9	BEFORE INSERT OR UPDATE ON username_test10	FOR EACH ROW11	EXECUTE PROCEDURE insert_username (username);12 13INSERT INTO username_test VALUES ('nothing');14INSERT INTO username_test VALUES ('null', null);15INSERT INTO username_test VALUES ('empty string', '');16INSERT INTO username_test VALUES ('space', ' ');17INSERT INTO username_test VALUES ('tab', '	');18INSERT INTO username_test VALUES ('name', 'name');19 20SELECT * FROM username_test;21