REGEX-Escape for: INSERT INTO robo.partner_profiles(username, password, partner_key) VALUES ($1, $2, $3);

Your Input:
Result, the escaped string:
INSERT INTO robo\.partner_profiles\(username, password, partner_key\) VALUES \(\$1, \$2, \$3\);


Ads

What must the escaping look like for:
INSERT INTO robo.partner_profiles(username, password, partner_key) VALUES ($1, $2, $3);

The excaped text for use in a regex is:

INSERT INTO robo\.partner_profiles\(username, password, partner_key\) VALUES \(\$1, \$2, \$3\);


Ads