select tz || ' ' || gmt_offset as tz, tz from timezones