Someone

broadworks=> CREATE VIEW broadworks_report AS
broadworks-> SELECT e.enterprise_id, e.name, g.group_id, g.name, u.group_user_id, u.first_name, u.last_name, u.extension, u.phone_number FROM group_user AS u
broadworks->    LEFT JOIN enterprise AS e ON u.fk_enterprise_id = e.pk_enterprise_id
broadworks->    LEFT JOIN enterprise_group AS g ON u.fk_group_id = g.pk_group_id
broadworks->    ORDER BY e.enterprise_id, u.extension;
ERROR:  column "name" duplicated