PostgreSQL: get all rows that contain an uppercase letter

How can I do the following stmt:

select * from table
where column has any uppercase letters; <-- how to write this

Answer

You can filter with a regex:

select * 
from mytable
where mycolumn ~ [A-Z]

Another approach is string comparison:

select * 
from mytable
where lower(mycolumn) <> mycolumn