' 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.comwrote:
Thanks for the replies, the most promising command so
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
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
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: