Postgresql INSERT triggers "0 row affected" workaround
You can try to catch the number of inserted rows using GET DIAGNOSTICS and then raise a notice/warning/whatever you prefer.  Here is a small illustration:

DO $$
    DECLARE cnt integer;
    BEGIN
        INSERT INTO b SELECT i FROM generate_series(1,9) t(i);
        GET DIAGNOSTICS cnt := ROW_COUNT;
        RAISE WARNING '% row(s) affected', cnt;
    END; 
$$;
-- gives:

WARNING:  9 row(s) affected
DO