Cacher is the code snippet organizer for pro developers

CREATE VIEW vw_message_detail AS
  SELECT message.id,
    message.created_at,
    message.deleted_at,
    message.user_id,
    message.updated_at,
    message.message,
    message.error_text,
    (message.states)::character varying(64) AS states,
    message.message_info_id,
    message.phone,
    user_address_book.name,
    user_address_book.province,
    user_address_book.countries,
    user_address_book.street,
    user_address_book.city
   FROM (message
     LEFT JOIN user_address_book USING (id))
  WHERE (user_address_book.deleted_at IS NULL);