plot.bat

SET Path=%WINDIR%\system32;%WINDIR%;%WINDIR%\System32\Wbem;&C:/"Program Files"/PostgreSQL/12/bin/pgsql2shp.exe -f C:/Users/Lia/AppData/Roaming/QGIS/QGIS3/profiles/default/layer_plot.shp -u postgres -P postgres MED "SELECT distritos.distrito,data_pqi.valor_pqi,data_pqi.chrono,geom FROM data_pqi INNER JOIN distritos ON data_pqi.geo=distritos.distrito WHERE (data_pqi.pqi='PQI02' AND data_pqi.geo='Porto') GROUP BY distritos.distrito, data_pqi.valor_pqi, data_pqi.chrono, distritos.geom ORDER BY distritos.distrito"