I used to generate shapefile from PostgreSQL database that is installed with PostGIS tables as templates (
Shapefiles generated just fine using the following command:
$pgsql2shp -f <path to new shapefile> -g <geometry column name> \ -h <hostname> -U <username> "<query>"
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?