If the flow rate is a fixed volume $V$ per second, the speed of the water is $u$ and the cross-sectional area of the pipe is $A$ then we have
$$V = Au$$
If the density of the water is $\rho$ then a mass $\rho V$ of water per second is hitting you at speed $u$. Lets make the simplest assumption, which is that all of the momentum of this water is transferred to your body. Then the force exerted by the water on your body is equal to the rate of change of momentum of the water, which is
$$\displaystyle F = \rho V u = \frac {\rho V^2}{A}$$
If we also assume that the jet does not spread out after leaving the pipe, then this force is applied over an area $A$, so the pressure exerted by the water on your body is
$$\displaystyle \frac F A = \frac {\rho V^2}{A^2}$$
Since $\rho$ and $V$ are fixed, the pressure is inversely proportion to the square of the pipe area $A$. This is why a water jet from a narrow pipe is more painful than from a wider pipe.