[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