[postgis-users] pgsql2shp - doesn't work with non-public schemas
rosolenn at rogers.com
rosolenn at rogers.com
Wed Aug 11 07:48:28 PDT 2004
i just started working with postgis-0.8.2 / postgresql-7.4.3 and tried
extracting a shape file from a table called wix.water_body_master
(schema = 'wix') ... it kept failing as below...
-bash-2.05b$ /usr/local/pgsql/bin/pgsql2shp -f /tmp/water_body.shp wix wix.water_body_master
Initializing... ERROR: relation "water_body_master" does not exist
also tried it with a wix.wix identifier
-bash-2.05b$ /usr/local/pgsql/bin/pgsql2shp -f /tmp/water_body.shp wix wix.wix.water_body_master
Initializing... Table wix.water_body_master does not exist
next, tried it against 'public' tables and it worked fine
/usr/local/pgsql/bin/pgsql2shp -f /tmp/water_body wix water_body_tmp
i'm not sure if this info is of any use to anyone but thought i should
let you know
norm
More information about the postgis-users
mailing list