loosebits:
Air pressure is a simple concept. Air pressure is the cumulative force exerted on a surface from the impact of gas molecules. It has nothing to do with the "weight" of the air column above your head as we are often taught as children (if it were the weight of the column of air, then pressurized cabins in space ships would be impossible - weightlessness). One of the consequences of the nature of gas pressure is that when you heat up the gas, the pressure increases (the heated up molecules move faster and thus strike surfaces with more force).
Water pressure seemingly has nothing little to do with the force from molecular impacts. Water at 90 degrees exerts the same pressure as water at 40 degrees (my guess is that this is due to the way a liquid heats with rotational and vibrational motions dominating over translation of the molecules). The weight of the water column doesn't quite seem to make sense either... wouldn't pressure from the weight of the water above you head push you down to the bottom - inside an underwater cave, wouldn't you need to take in account the weight of the rock over your head? Is it simply a matter of the water trying to occupy the space you are in? If that is the case, why does it increase with depth without depending on your volume (the amount of space the water is trying to reclaim)? What would be the pressure at the center of a sphere of water 66 feet across in a weightless environment?
Anyone have any insights into the nature of water pressure - what causes it?
In fact, you have it at the same time right and wrong.
Yes, pressure is due to molecular impact (in gas as well as in water). But these molecular impacts also have the effect to expand the fluid -> increase its volume. When does this expansion stops? when pressure strength is equilibrater by another strength. In an open environment (atmosphere, ocean), this equilibrium is reached when pressure strength is equal to the weight of the (water +) air column. When in confined area, by the resistance of the confinment material, eventually helped by outside pressure.
Which means that confinment is a way to keep pressure,
if the confinment material (bottle or other) if completely rigid.
The proof that confinement keep pressure is the degaseing of the coca bottle when opened: before opening, high pressure -> no bubbles, after opening atmospheric pressure -> bubbles.
Now if the confinment material is only partly rigid, there will be a loss of pressure, but not a complete equalization with outside pressure.
Liquids (water) react differently than gas because the equation linking volume, temperature and pressure is no more PV=nRT, but it does not mean that there is no corresponding equation. Only liquids are
almost incompressible, which means that volume changes, or temperature effect are very tiny, and neglected as a first approximation.