DO $$
BEGIN
   FOR counter IN 1..1500 LOOP
   RAISE NOTICE 'Counter: %', counter;

INSERT INTO public.m_ch_value(
	m_ch_value_id, ad_client_id,  ad_org_id,  isactive,  createdby,   m_characteristic_id,   name,   issummary,   add_products,  updatedby)
    VALUES (
    (SELECT array_to_string(
        ARRAY(
            SELECT chr(
                (65 + round(random() * 25)
            )
        :: integer) 
    FROM generate_series(1,32)), '')), --m_ch_value_id
    '39363B0921BB4293B48383844325E84C', -- ad_client_id 
	'0', -- ad_org_id
	'Y', --isactive 
	'100', --createdby 
    'E33C375A61574ADAB7CFA16AD1A96D6C',-- m_characteristic_id
    counter,-- name
    'N',--issummary,
    'N',--add_products
    '100'--updatedby
    );

   END LOOP;
END; $$