[postgis-users] pgsql2shp error

[smas036]

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.