Taking a different tack from PostGIS and QGIS connection using queries?, I am trying the pgsql2shp command line.
I get some selections but when I try the join I get no success with the following error:
pgsql2shp -f "C:\....\teste2.shp" -h localhost -p 5432 -u postgres -P postgres database_name "SELECT* FROM table1 LEFT OUTER JOIN table2 ON table1.dicofre = table2.reside" ERROR:
Initializing... Table dicofre = table2.reside does not exist Why is that happening?
أكثر...
I get some selections but when I try the join I get no success with the following error:
pgsql2shp -f "C:\....\teste2.shp" -h localhost -p 5432 -u postgres -P postgres database_name "SELECT* FROM table1 LEFT OUTER JOIN table2 ON table1.dicofre = table2.reside" ERROR:
Initializing... Table dicofre = table2.reside does not exist Why is that happening?
أكثر...