Did you verify that the data in the shapefile is correct when you run the command with just the table name?
Hang on a second... WHERE 'ID' < '20' is never true. That's why you're getting an empty table. 'ID' is a string, as is '20'. I think you mean to say where your ID column value is less than 20, correct? Single quotes mean 'this is a string'. Are your ID values strings (varchars) or integers? If integers, it'll be faster to use 20 as an integer (without the single quotes) rather than as a string. Maybe the problem is with 'id' by itself, so try fully qualifying it: pgsql2shp -f [path] -h [myhost] -p [port] -u [user] -P [password] [database] "SELECT * FROM table1 WHERE table1.id < 20" On Wed, Aug 11, 2010 at 5:50 AM, smas036 <sina.masoud.ans...@gmail.com>wrote: > > 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 > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > -- Jeff Adams Azavea (formerly Avencia) | 340 N 12th St, Ste 402, Philadelphia, PA jad...@azavea.com | T 215.701.7717 | F 215.925.2663 Web azavea.com | Blog azavea.com/blogs | Twitter @azavea<http://twitter.com/azavea>
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users