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

Match Information

Detailed match information will be displayed here automatically.

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>.*)\))?

PostgreSQL 12.6, Aurora PostgreSQL release 4.1 (Deprecated on July 15, 2022)
PostgreSQL 12.4, Aurora PostgreSQL release 4.0 (Deprecated on July 15, 2022)
Aurora PostgreSQL release 14.3.1, July 6, 2022
PostgreSQL 9.6.8, Aurora PostgreSQL release 1.2 (Deprecated on October 28, 2021)
PostgreSQL 9.6.8, Aurora PostgreSQL release 1.2.4
PostgreSQL 14.5, Aurora PostgreSQL release 1.2
Aurora PostgreSQL release 14.3.1, Deprecated on October 28, 2021)

Extraction

PostgreSQL 12.6, Aurora PostgreSQL release 4.1 (Deprecated on July 15, 2022)
PostgreSQL 12.4, Aurora PostgreSQL release 4.0 (Deprecated on July 15, 2022)
Aurora PostgreSQL release 14.3.1, July 6, 2022
PostgreSQL 9.6.8, Aurora PostgreSQL release 1.2 (Deprecated on October 28, 2021)
PostgreSQL 9.6.8, Aurora PostgreSQL release 1.2.4
PostgreSQL 14.5, Aurora PostgreSQL release 1.2
Aurora PostgreSQL release 14.3.1, Deprecated on October 28, 2021)