This doesn't explain or fix anything, but you could try using a temp table:
create table temp_for_export as select * from table1 where id < '20' Then pgsql2shp -f [path] -h [myhost] -p [port] -u [user] -P [password] [database] temp_for_export and see what that does. Is there any chance your host, user or database is incorrect on the pgsql2shp command line, so pgsql2shp is accessing a different "table1" than you're looking at in the shell? On Tue, Aug 10, 2010 at 6:44 AM, smas036 <[email protected]>wrote: > > Update: The error is the same whether the column id is lower case or > uppercase. > > Using single quotes 'id' produces a different error. Possibly an > improvement: > > ERROR: Cannot determine geometry type (empty table). > > The dump works fine when a table is specified and there is no query, > however > there is a warning: > > WARNING: Cannot determine spatial reference (empty table or unknown spatial > ref). No prj file will be generated. > > Any help is appreciated > > Sina > -- > View this message in context: > http://old.nabble.com/pgsql2shp-error-tp29384180p29396396.html > Sent from the PostGIS - User mailing list archive at Nabble.com. > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
