pgsql2shp fails with named schema on windows 64
|Reported by:||robe||Owned by:||robe|
This is a note from Jeff: http://lists.osgeo.org/pipermail/postgis-devel/2013-March/023297.html
I just tested and confirmed its the same issue with 2.0.3. I think we had a similar issue a while back with shp2pgsql and perhaps because that is more heavily tested it was caught there.
pgsql2shp -f "c:/test.shp" -g geom -u "postgres" -h t -p 5432 -P "mypassword" mygisdb public.constrained_geoms
The is is the . is being put in the wrong spot this is what the log shows:
SELECT a.attname, a.atttypid, a.atttypmod, a.attlen FROM pg_attribute a, pg_class c, pg_namespace n WHERE n.nspname = 'public.' AND a.attrelid = c.oid AND n.oid = c.relnamespace AND a.atttypid != 0 AND a.attnum > 0 AND c.relname = 'constrained_geoms'
note the public. instead of public