Расширение для подготовки текста

CREATE TABLE typo_rules (
  id INTEGER PRIMARY KEY GENERATED ALWAYS AS IDENTITY, 
  pattern text NOT NULL, replace_by text NOT NULL, 
  seeded BOOLEAN DEFAULT FALSE
);
GRANT SELECT ON typo_rules TO public;
INSERT INTO typo_rules(pattern, replace_by, seeded) VALUES 
  ('(^|\s)\"(\S)', '\1«\2', TRUE), 
  ('(\S)\"(\s|$)', '\1»\2', TRUE), 
  ('(^|\s)-(\s|$)', '\1—\2', TRUE);
 
CREATE FUNCTION typo(INOUT s text) AS $$ 
DECLARE 
    r record;
BEGIN 
    FOR r IN (
        SELECT pattern, replace_by 
        FROM @extschema @.typo_rules 
        ORDER BY id
    ) 
    LOOP 
        s := regexp_replace(s, r.pattern, r.replace_by, 'g');
    END LOOP;
END;
$$ LANGUAGE plpgsql STABLE;
 
SELECT pg_extension_config_dump('typo_rules', 'WHERE NOT seeded');
SELECT pg_extension_config_dump('typo_rules_id_seq', '');