Using WITH clause with INSERT statement in POSTGRESQL
(Not tested in Postgres) Is this what you need?

INSERT INTO public.table_1(cust_code, issue, status, created_on)
SELECT cust_code, 'New Issue', 'Open', current_timestamp 
FROM cust 
WHERE cust_id=11