-- View: public.user_information
 
-- DROP VIEW public.user_information;
 
CREATE OR REPLACE VIEW public.user_information
AS
SELECT concat(user_details.first_name, ' ', user_details.last_name) AS full_name,
    user_details.user_id
   FROM users
     JOIN user_details ON users.id = user_details.user_id;
ALTER TABLE public.user_information
    OWNER TO postgres;
 
 
 