PG特殊字符的转义

• 实例1

imos=# select * from test;
 name 
------
 c_d
 ab
 _b_c
(3 rows)

imos=#  select * from test where name like '_b%';
 name 
------
 ab
 _b_c
(2 rows)

imos=#  select * from test where name like 'd_b%' escape 'd';
 name 
------
 _b_c
(1 row)
imos=#  select * from test where name like '\_b%' ;
 name 
------
 _b_c
(1 row)