Error: Command failed: psql -p 5433 -U postgres -d mbk_ac_khmelnytskyi -F" " -c " SELECT lease_num as contract_num, lease_dt as contract_bdate, lease_end_dt as contract_edate, (select array_to_string(array_agg( (select account_name from crm_acc.crm_account where account_id=hh.account_id) ),',') from parcel_orenda.orenda_lease_orendar hh where lease_sid=a.lease_sid) as conragent, lease_area as area, (select array_to_string(array_agg(cad_num),',') from parcel_orenda.orenda_lease_object where lease_sid=a.lease_sid) as cad_num, (select st_x(st_centroid(geom)) ||','||st_x(st_centroid(geom)) as latlng from data_parcel.cad_parcel where b.main_sid=cad_parcel_id) FROM parcel_orenda.orenda_main b left join parcel_orenda.orenda_lease a on a.main_sid=b.main_sid where state_id='01' " > /data/softpro/work/mbk/ac_khmelnytskyi/files/temporary/54738c70-ed1c-11ee-9fa2-e1c60ab7d238/output.txt ERROR: column hh.account_id does not exist LINE 8: ...nt_name from crm_acc.crm_account where account_id=hh.account... ^