I have a database table which has some values with non-printable character, my question is how to find the rows having those characters. Is there any way to create the select query on some columns and use a regex to find the rows?

Thanks for your answers!

I’ve tried something like CHECK (my_column ~ ‘^[x00-x7F]*$’), but in my case I don’t want to add a constrain, I want to find the rows.