PostgreSQL: Find records with single quotes
'%''%'  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 $$%''%$$