yancho@Ubuntu:~/thesis$ pgsql2shp -f myshp country "SELECT buffer(the_geom, 1)::geometry as theextenet, city_name
FROM city
WHERE city_name = 'Pierre';"
Preparing table for user query... Done.
Initializing... Done (postgis major version: 1).
Output shape: Polygon
Dumping: XX [1 rows].
yancho@Ubuntu:~/thesis$ pgsql2shp -f myshp country "SELECT buffer(the_geom, 1)::geometry as theextenet, city_name
FROM city
WHERE city_name = 'Milwaukee';"
Preparing table for user query... Done.
Initializing... Done (postgis major version: 1).
Output shape: Polygon
Dumping: XX [1 rows].