\c table_name_test_db;
set dolphin.lower_case_table_names to 0;
create table t1(c1 int);
create table t2(c1 int);
create trigger tg_case_1 before insert on t1 for each row update t2 set c1 = c1 + 1;
create trigger TG_CASE_1 before insert on t1 for each row update t2 set c1 = c1 + 1;
create schema s1;
create schema S1;
create table s1.t1(c1 int);
create table s1.t2(c1 int);
create table S1.t1(c1 int);
create table S1.t2(c1 int);
create trigger s1.tg_case_2 before insert on s1.t1 for each row update s1.t2 set c1 = c1 + 1;
create trigger s1.TG_CASE_2 before insert on s1.t1 for each row update s1.t2 set c1 = c1 + 1;
create trigger S1.tg_case_3 before insert on S1.t1 for each row update S1.t2 set c1 = c1 + 1;
create trigger S1.TG_CASE_3 before insert on S1.t1 for each row update S1.t2 set c1 = c1 + 1;
select tgname from pg_trigger where lower(tgname) like 'tg_case_%' order by tgname asc;

drop trigger tg_case_1;
drop trigger TG_CASE_1;
drop trigger s1.tg_case_2;
drop trigger s1.TG_CASE_2;
drop trigger S1.tg_case_3;
drop trigger S1.TG_CASE_3;
drop table t1;
drop table t2;
drop schema s1 cascade;
drop schema S1 cascade;