>Hi folks.
>I'm using the following regular expression to validate some strings:
>
>[0-9]+; [0-9]+ [0-9]+ SCHEMA - \b(information-schema|(?!pg_))\w+\b [a-zA-Z]+
>
>8; 2615 1490850 SCHEMA - e9999 postgres
>8; 2615 1490850 SCHEMA - pg_catalog postgres
>8; 2615 1490850 SCHEMA - pg_temp postgres
>8; 2615 1490850 SCHEMA - information-schema postgres
>8; 2615 1490850 SCHEMA - information-test postgres
>8; 2615 1490850 SCHEMA - information postgres
>8; 2615 1490850 SCHEMA - schema postgres
>8; 2615 1490850 SCHEMA - myinformation-schema postgres
>8; 2615 1490850 SCHEMA - information-schemas postgres
>
>Test string - Expected result - Given result
>String 1 - Valid - Valid
>String 2 - Invalid - Invalid
>String 3 - Invalid - Invalid
>String 4 - Invalid - Invalid
>String 5 - Valid - Invalid (Error)
>String 6 - Valid - Valid
>String 7 - Valid - Valid
>String 8 - Valid - Invalid (Error)
>String 9 - Valid - Valid
>
>Please, someone could help me to find the right pattern?
Sure - but can you explain exactly what the pattern needs to verify?
Looking at your pattern - too much guesswork - I cannot find what you want
Gregory