ALTER TABLE  packinglist_products
ALTER COLUMN batchno TYPE VARCHAR USING batchno::VARCHAR;
ALTER TABLE  qcp4_products
DROP COLUMN noofboxes;