2 posts tagged with "sql"

SQL随录

October 17, 2022 · One min read

陈大哥

SELECT
    proname 
FROM
    pg_proc 
WHERE
    prosrc LIKE'%table_name%';

October 14, 2022 · One min read

陈大哥

SELECT 
    SUBSTRING( ( table.key -> 0- > 'rule' -> 0 ) :: TEXT, '=*([0-9a-zA-Z]*);' ) AS hash 
FROM
    table;