Postgresql截取字符串

---

Postgresql截取字符串

SELECT DISTINCT split_part(object_identity
                          ,'.'
                          ,2) AS table_name
  FROM ddl_audit_log
 WHERE 1 = 1
   AND ddl_tag = 'CREATE TABLE'
   AND object_type = 'table'
   AND schema_name = 'tzq'
   AND object_identity NOT LIKE 'tzq.sys_%'
   AND ip_addr = '10.234.65.40/32'
   AND split_part(object_identity
                 ,'.'
                 ,2) <> 'tzq_scope_t'
 ORDER BY 1 DESC;