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...