PostgreSQL: Find records with single quotes I have identified records in one of our tables with TWO single quotes.
So the record field appears as: ''
What SQL could I utilize to find all the record occurrences with ''
I have tried '%' and also '%''%' with no success.
'%''%'  will look for entries with a one single quote (as a single quote is escaped by doubling it). If you want to search for two single quotes, you need 4 quotes (because of the escaping), e.g.:
where the_column like '%''''%'

alternatively you can use dollar quoting to avoid the escaping
where the_column like $$%''%$$