regex - regular expression - excluding specific chars

Question

I am trying to write a regular expression matching a set without some chars.

For example, it matches [ a-zA-Z]* but excludes i,o,q,I,O,Q.

So: "A fat cat" matches, "Boy" doesn't.

Looks like it can be [ a-hj-npr-zA-HJ-NPR-Z]*.

Is there a simpler version for this?

Btw, I'm using it in PostgreSQL, but I think it should be a standard expression.

Answer 1

You can use negative lookahead for this as Postgresql support lookaheads:

(?![ioqIOQ])[A-Za-z ]

To make it match complete line use:

^(?:(?![ioqIOQ])[A-Za-z ])+$

RegEx Demo