Real timezones that observe Daylight Savings Time

drop view if exists canonical_real_country_with_dst cascade;

create view canonical_real_country_with_dst as
select
  name,
  std_abbrev,
  dst_abbrev,
  std_offset,
  dst_offset,
  country_code,
  region_coverage
from extended_timezone_names
where
  lower(status) = 'canonical'                                         and

  std_offset <> dst_offset                                            and

  country_code is not null                                            and
  country_code <> ''                                                  and

  lat_long is not null                                                and
  lat_long <> ''                                                      and

  name not like '%0%'                                                 and
  name not like '%1%'                                                 and
  name not like '%2%'                                                 and
  name not like '%3%'                                                 and
  name not like '%4%'                                                 and
  name not like '%5%'                                                 and
  name not like '%6%'                                                 and
  name not like '%7%'                                                 and
  name not like '%8%'                                                 and
  name not like '%9%'                                                 and

  lower(name) not in (select lower(abbrev) from pg_timezone_names)    and
  lower(name) not in (select lower(abbrev) from pg_timezone_abbrevs);