Hello, I am trying to output a shapefile from PostGIS using a command with the following format:
pgsql2shp -f [path] -h [myhost] -p [port] -u [user] -P [password] [database] "SELECT * FROM table1 WHERE id < '20'" But I receive the following error: Preparing table for user query... Failed: ERROR: column "id" does not exist I am able to access this column from the PostgreSQL shell. Any ideas? Cheers Sina -- View this message in context: http://old.nabble.com/pgsql2shp-error-tp29384180p29384180.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