name=id, type=int8
name=merch_type_code, type=int4
name=merch_id, type=text
name=ver, type=int8
name=status_code, type=int4
name=merch_name, type=text
name=merch_reg_no, type=text
name=bank_code, type=text
name=bank_account_no, type=text
name=bank_account_name, type=text
name=addr_1, type=text
name=addr_2, type=text
name=addr_city, type=text
name=addr_post, type=text
name=addr_state_code, type=int4
name=addr_country_code_alpha_2, type=text
name=person_in_charge, type=text
name=phone_number, type=text
name=fax_number, type=text
name=email, type=text
name=website_url, type=text
name=pic_1_url, type=text
name=pic_2_url, type=text
name=created_by, type=text
name=updated_by, type=text
name=dt_create, type=timestamptz
name=dt_update, type=timestamptz
name=mdr_rate, type=numeric
name=sc_rate, type=numeric
name=pic_2_file, type=text
name=pic_1_file, type=text
name=company_name, type=text
SQL upsert=INSERT INTO i3s_merchant (merch_type_code,merch_id,status_code,merch_name,merch_reg_no,bank_code,bank_account_no,bank_account_name,addr_1,addr_2,addr_city,addr_post,addr_state_code,addr_country_code_alpha_2,person_in_charge,phone_number,fax_number,email,website_url,pic_1_url,pic_2_url,created_by,updated_by,mdr_rate,sc_rate,pic_2_file,pic_1_file,company_name) VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,$25,$26,$27,$28) ON CONFLICT (merch_id) DO UPDATE SET merch_type_code=$1,status_code=$3,merch_name=$4,merch_reg_no=$5,bank_code=$6,bank_account_no=$7,bank_account_name=$8,addr_1=$9,addr_2=$10,addr_city=$11,addr_post=$12,addr_state_code=$13,addr_country_code_alpha_2=$14,person_in_charge=$15,phone_number=$16,fax_number=$17,email=$18,website_url=$19,pic_1_url=$20,pic_2_url=$21,created_by=$22,updated_by=$23,mdr_rate=$24,sc_rate=$25,pic_2_file=$26,pic_1_file=$27,company_name=$28)
Version=
Row count=0