Regular Expressions 101

Explanation

Pro

Group 1(PostgreSQL (?P<psql_major>\d{1,2})\.(?P<psql_minor>\d{1,2})(?P<psql_opt_patch>\.\d{1,2})?, )?

?repeats the group contents below at most once:

PostgreSQL the literal text PostgreSQL (case sensitive)

Group psql_major(?P<psql_major>\d{1,2})

\d{1,2}a Unicode decimal digit, repeated between 1 and 2 times

\.the literal . (46₁₀ / 56₈ / 2E₁₆)

Group psql_minor(?P<psql_minor>\d{1,2})

\d{1,2}a Unicode decimal digit, repeated between 1 and 2 times

Group psql_opt_patch(?P<psql_opt_patch>\.\d{1,2})?

?repeats the group contents below at most once:

\.the literal . (46₁₀ / 56₈ / 2E₁₆)

\d{1,2}a Unicode decimal digit, repeated between 1 and 2 times

, the literal text ,

Aurora PostgreSQL release the literal text Aurora PostgreSQL release (case sensitive)

Group aurora_psql_major(?P<aurora_psql_major>\d{1,2})

\d{1,2}a Unicode decimal digit, repeated between 1 and 2 times

\.the literal . (46₁₀ / 56₈ / 2E₁₆)

Group aurora_psql_minor(?P<aurora_psql_minor>\d{1,2})

\d{1,2}a Unicode decimal digit, repeated between 1 and 2 times

Group aurora_psql_opt_patch(?P<aurora_psql_opt_patch>\.\d{1,2})?

?repeats the group contents below at most once:

\.the literal . (46₁₀ / 56₈ / 2E₁₆)

\d{1,2}a Unicode decimal digit, repeated between 1 and 2 times

Group release_or_deprecation(?P<release_or_deprecation>\,\s(?P<release_data>.*)|\s\(Deprecated on (?P<deprecation_date>.*)\))?

?repeats the group contents below at most once:

1st Alternative\,\s(?P<release_data>.*)

\,the literal , (44₁₀ / 54₈ / 2C₁₆)

\sa Unicode whitespace character

Group release_data(?P<release_data>.*)

.*any Unicode character (except for line terminators), repeated any number of times

2nd Alternative\s\(Deprecated on (?P<deprecation_date>.*)\)

\sa Unicode whitespace character

\(the literal ( (40₁₀ / 50₈ / 28₁₆)

Deprecated on the literal text Deprecated on (case sensitive)

Group deprecation_date(?P<deprecation_date>.*)

.*any Unicode character (except for line terminators), repeated any number of times

\)the literal ) (41₁₀ / 51₈ / 29₁₆)

Global pattern flags

m modifier: multiline. Causes ^ and $ to match the start and end of each line, not only the start and end of the string

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

Unit Test Summary

No unit tests

Add a test to get started

Quick Reference

25 tokens

Regular Expression

(PostgreSQL (?P<psql_major>\d{1,2})\.(?P<psql_minor>\d{1,2})(?P<psql_opt_patch>\.\d{1,2})?, )?Aurora PostgreSQL release (?P<aurora_psql_major>\d{1,2})\.(?P<aurora_psql_minor>\d{1,2})(?P<aurora_psql_opt_patch>\.\d{1,2})?(?P<release_or_deprecation>\,\s(?P<release_data>.*)|\s\(Deprecated on (?P<deprecation_date>.*)\))?

Unit Tests

There are no unit tests.