SELECT
    t.name AS tz_name,
    t.abbrev AS tz_abbrev,
    t.utc_offset,
    t.is_dst
FROM pg_timezone_names t
WHERE t.name !~~ 'posix/%'::text
ORDER BY t.name