I used to generate shapefile from PostgreSQL database that is installed with PostGIS tables as templates (geometry_columns and spatial_ref_sys)
Shapefiles generated just fine using the following command:
$pgsql2shp -f -g \ -h -U ""No I have a new database with PostGIS 2.0 which installed as a plugin. There is no PostGIS templates. So when I tried generating shapefiles using the above command I got the following error:
Any idea how can i export shapefiles in this case?
أكثر...
Shapefiles generated just fine using the following command:
$pgsql2shp -f -g \ -h -U ""No I have a new database with PostGIS 2.0 which installed as a plugin. There is no PostGIS templates. So when I tried generating shapefiles using the above command I got the following error:

Any idea how can i export shapefiles in this case?
أكثر...