Tight sandstone reservoirs are affected by various factors such as pore structure, formation water salinity, and siliceous cementation, which lead to the abnormal phenomenon of high-resistivity water layers and increase the difficulty in identifying gas and water layers by conventional logging. In this study, the pore types and pore size distribution characteristics of tight sandstone reservoirs were firstly determined by NMR and high-pressure mercury injection experiments, and then the iterative least-square method was used to automatically optimize the inversion method of pseudo-capillary pressure curve and search for the optimal conversion coefficient. Finally, the apparent free water porosity was inversed and the fluid identification standard was obtained and applied. The results showed that the reservoirs mainly developed intergranular pores, cutting solution pores, and intergranular pores. The pore throats were poorly sorted, and the displacement pressure was high. The median radius ranged from 0.01 to 0.48 μm, and the main peak range was from 0.02 to 0.06 μm. Pores were of mainly small-hole fine throat type. In the inversion results of the optimal conversion coefficient, the correlation coefficient between the aperture parameters and the results of high-pressure mercury injection experiments was greater than 0.93. According to the fluid property identification standard based on nuclear magnetic apparent free water porosity, the high-resistivity water layers were effectively identified and its coincidence rate with the final field test was 10.7% higher than that of the conventional method. This identification method can be used to identify complex fluids in tight sandstone reservoirs.