I need to export from postgis some data obtaining the center of my polygons, now I'm working on Ubuntu.My command looks like this:
./pgsql2shp -f /home/me/ESTADOS_POINT -h localhost -p 5432 -P whatever -u postgres estados "SELECT cve_ent, nom_ent, nombre, per_capita, ST_PointOnSurface(geom) AS geom FROM estados;"But this only sends me an error: Table "SELECT does not exist. The help says:
RELEASE: 2.1.5 (r13152).USAGE: pgsql2shp [] [.] pgsql2shp [] Then I try this way:
./pgsql2shp -f /home/me/ESTADOS_POINT -h localhost -p 5432 -P whatever -u postgres estados \"SELECT cve_ent, nom_ent, nombre, per_capita, ST_PointOnSurface(geom) AS geom FROM estados;\"But it doesn't work, I was searching a lot about this problem but no one has this problem. And at this moment I don't have the org2org binary. I think it could be about the version (2.1.5), but how can I know?
أكثر...
./pgsql2shp -f /home/me/ESTADOS_POINT -h localhost -p 5432 -P whatever -u postgres estados "SELECT cve_ent, nom_ent, nombre, per_capita, ST_PointOnSurface(geom) AS geom FROM estados;"But this only sends me an error: Table "SELECT does not exist. The help says:
RELEASE: 2.1.5 (r13152).USAGE: pgsql2shp [] [.] pgsql2shp [] Then I try this way:
./pgsql2shp -f /home/me/ESTADOS_POINT -h localhost -p 5432 -P whatever -u postgres estados \"SELECT cve_ent, nom_ent, nombre, per_capita, ST_PointOnSurface(geom) AS geom FROM estados;\"But it doesn't work, I was searching a lot about this problem but no one has this problem. And at this moment I don't have the org2org binary. I think it could be about the version (2.1.5), but how can I know?
أكثر...