Thanks for the replies, the most promising command so far is: pgsql2shp -f [path] -h [myhost] -p [port] -u [user] -P [password] [database] "SELECT * FROM table1 WHERE 'ID' < '20'"
Which has the output: Preparing table for user query... Done. Initializing... WARNING: Cannot determine spatial reference (empty table or unknown spatial ref). No prj file will be generated. ERROR: Cannot determine geometry type (empty table) I think the query is correct as other combinations if single and double quotes around field values produce "...column does not exist..." or "The system cannot find the file specified." I believe the command parameters before the query are correct as the command without a query: pgsql2shp -f [path] -h [myhost] -p [port] -u [user] -P [password] [database] [table] works fine. It would be possible to produce a table from a query and use this command but I wonder if there is a performance loss in doing so... -- View this message in context: http://old.nabble.com/pgsql2shp-error-tp29384180p29406665.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
