I'm new to PostGIS/QGIS, and I was looking at using the PostGIS SQL Editor plugin (v.2.0.0) instead of the OpenJump tool recommended in PostGIS in Action 2nd ed. However, I am having problems following the plugin help advice stating that 'The Path to pgsql2shp must be added to the system PATH environment'.
I already have the relevant PostgreSQL paths (;C:\Program Files\PostgreSQL\9.6\bin;C:\PostgreSQL\9.6\lib) added to my system variables (psql works fine from the command line), but I am still getting the error ''pgsql2shp' is not recognized as an internal or external command, operable program or batch file.' from the QGIS plugin.
I'm using QGIS 2.18.4, PostgreSQL 9.6, PostGIS 2.3.2 on Windows 7 Enterprise.