add missing column in pgsql script, add with timezone, update views