regex101: PCRE (Legacy) Substitution Workspace

1st Alternative#PostgreSQL v10+ (?<delimiter>; [;\s]*) #semicolon, followed by semicolons and spaces

Comment:PostgreSQL v10+

Group delimiter(?<delimiter>; [;\s]*)

; the literal text ;

Character Class[;\s]*

*matches any number of characters from the set below:

;the literal ; (59₁₀ / 73₈ / 3B₁₆)

\sany whitespace character

Comment:semicolon, followed by semicolons and spaces

2nd Alternative '(?>[^']+|'')*' #String Constants

'the literal text '

Atomic Group(?>[^']+|'')*

*repeats the group contents below any number of times:

1st Alternative[^']+

Negated Character Class[^']+

+matches at least one character outside the set below:

'the literal ' (39₁₀ / 47₈ / 27₁₆)

2nd Alternative''

''the literal text ''

' the literal text '

Comment:String Constants

3rd Alternative \b[Ee]'(?>[^\\']+|''|\\.)*' #String Constants With C-Style Escapes

\ban ASCII word boundary

Character Class[Ee]

Ethe literal E (69₁₀ / 105₈ / 45₁₆) (case sensitive)

ethe literal e (101₁₀ / 145₈ / 65₁₆) (case sensitive)

'the literal ' (39₁₀ / 47₈ / 27₁₆)

Atomic Group(?>[^\\']+|''|\\.)*

*repeats the group contents below any number of times:

1st Alternative[^\\']+

Negated Character Class[^\\']+

+matches at least one character outside the set below:

\\the literal \ (92₁₀ / 134₈ / 5C₁₆)

'the literal ' (39₁₀ / 47₈ / 27₁₆)

2nd Alternative''

''the literal text ''

3rd Alternative\\.

\\the literal \ (92₁₀ / 134₈ / 5C₁₆)

.any character

' the literal text '

Comment:String Constants With C-Style Escapes

4th Alternative (?<stringDollarTag>\$[a-zA-Z\d_]*\$) #Dollar-Quoted String [^$]*+ #speed improves .*? \k<stringDollarTag>

Group stringDollarTag(?<stringDollarTag>\$[a-zA-Z\d_]*\$)

\$the literal $ (36₁₀ / 44₈ / 24₁₆)

Character Class[a-zA-Z\d_]*

*matches any number of characters from the set below:

a-zone character from a (97₁₀) to z (122₁₀) (case sensitive)

A-Zone character from A (65₁₀) to Z (90₁₀) (case sensitive)

\da digit

_the literal _ (95₁₀ / 137₈ / 5F₁₆)

\$the literal $ (36₁₀ / 44₈ / 24₁₆)

Comment:Dollar-Quoted String

Negated Character Class[^$]*+

*+matches any number of characters outside the set below:

$the literal $ (36₁₀ / 44₈ / 24₁₆)

Comment:speed improves

.*?any character, repeated any number of times

\k<stringDollarTag>the text saved by group stringDollarTag

5th Alternative "(?>[^"]+|"")*"

"the literal text "

Atomic Group(?>[^"]+|"")*

*repeats the group contents below any number of times:

1st Alternative[^"]+

Negated Character Class[^"]+

+matches at least one character outside the set below:

"the literal " (34₁₀ / 42₈ / 22₁₆)

2nd Alternative""

""the literal text ""

" the literal text "

6th Alternative #singe-line comment (?<singeLineComment>-- [^\r\n]*+)

Comment:singe-line comment

Group singeLineComment(?<singeLineComment>-- [^\r\n]*+)

7th Alternative #multi-line comment (?<MutilineComment> /\* [^*/]*+ (?> [^*/]++ | \*[^/] | /[^*] | (?&MutilineComment) )*+ \*/ )

Global pattern flags

s modifier: single line. Allows a dot to match line terminators

x modifier: extended. Ignores unescaped whitespace and comments outside character classes

X modifier: eXtra. A \ followed by a letter with no special meaning causes an error

g modifier: global. Finds all matches instead of stopping after the first

Search reference

Regular Expression

#PostgreSQL v10+
   (?<delimiter>; [;\s]*) #semicolon, followed by semicolons and spaces
|  '(?>[^']+|'')*'                   #String Constants
    |   \b[Ee]'(?>[^\\']+|''|\\.)*'       #String Constants With C-Style Escapes
    |   (?<stringDollarTag>\$[a-zA-Z\d_]*\$) #Dollar-Quoted String
            [^$]*+  #speed improves
            .*?
        \k<stringDollarTag>
|  "(?>[^"]+|"")*"
|  #singe-line comment
   (?<singeLineComment>-- [^\r\n]*+)
|  #multi-line comment
   (?<MutilineComment>
        /\*
          [^*/]*+
          (?> [^*/]++
            | \*[^/]
            | /[^*]
            | (?&MutilineComment)
          )*+
        \*/
   )

Test String
New

CREATE UNIQUE INDEX/*CONCUR-
RENTLY;*/IF NOT EXISTS custom_query_group_name_name_uindex 

ON public.custom_query_group_name (lower(name)); ;  
;
--CREATE INDEX /*CONCURRENTLY;*/ IF NOT EXISTS custom_query_group_name_name_trigram_index ON public.custom_query_group_name USING GIN (lower(name) gin_trgm_ops);
  ;
  ;
  ;
CREATE INDEX /*CONCURRENTLY*/ IF NOT EXISTS v3_company_name_trigram_index ON public.v3_company USING GIN (lower(name) gin_trgm_ops);
 ;
-- PostgreSQL
$function$
BEGIN
    RETURN ($1 ~ $q$[\t\r\n\v\\]$q$);
END;
$function$;

-- PostgreSQL
SELECT $$Жанна д'Арк$$, $SomeTag$Жанна д'Арк$SomeTag$;

SELECT 'abc\''\\def', "abc\""\\def";
SELECT 123;

Substitution
Processing...

$0

Regular Expression

Test StringNew

SubstitutionProcessing...

Test String
New

Substitution
Processing...