1-- Find basic information about an user account 2select 3 u.id, 4 u.full_name, 5 u.registration, 6 u.user_role, 7 u.email, 8 u.phone 9from public.user_account as u 10where u.id = $1;