PG特殊字符的转义

efc=# select  tablename from pg_tables where tablename like  E'test\_%' and tablename not in ('test','test_defautl');
  tablename   
--------------
 test_default
 testu
 testu_1
 testu_2
(4 rows)

efc=# select  tablename from pg_tables where tablename like  'test\_%' and tablename not in ('test','test_defautl');
  tablename   
--------------
 test_default
(1 row)
【推广】 免费学中医，健康全家人
原文地址：https://www.cnblogs.com/yldf/p/11899945.html