You first need to determine if you have a single (in-tank) pump or if you have a two pump system, (the in-tank pump being low pressure and the downstream pump being the high pressure pump). You need at least one high pressure pump in order for the engine to receive adequate fuel flow. You can NOT determine if you have a one or two pump system based solely on whether your car is turbo or non-turbo as the fuel system configurations got kinda wonky toward the end of the 940 production run.
So once you’ve identified if you have a single or double pump system you need to check the pressure specs of the various pumps available. Whether the high pressure pump is in the tank (as in the case of the single pump system), or under the drivers floor (double pump system), it needs to put out upwards to 50 psi.
If it’s the tank pump of a dual pump system then it doesn’t need to be of particularly high pressure - just enough to push the fuel up to the high pressure pump.