In addition to pgsql2shp command join error, the next command line works fine in order to join a table to a shapefile but the result is a dbf table and not a shapefile as I want. I see that exists a -g geom parameter but I try and it doesn't work. How do I get the geometry?
pgsql2shp -f "C:\....\teste2.shp" -h localhost -p 5432 -u postgres -P postgres database_name "SELECT table2.example, table2.example2 FROM table1 LEFT OUTER JOIN table2 ON table1.dicofre = table2.reside"
أكثر...
pgsql2shp -f "C:\....\teste2.shp" -h localhost -p 5432 -u postgres -P postgres database_name "SELECT table2.example, table2.example2 FROM table1 LEFT OUTER JOIN table2 ON table1.dicofre = table2.reside"
أكثر...